macro - copy/paste

Hello everyone, I am noticing a problem with my macro, but I can't find where I broke it. The reason it broke is because I was trying to fix a problem where my macro deletes the =SOM formulas that were in the same column. Here is an explanation of what my macro does: My macro needs to copy...

Hello: I am looking to create a macro that will be a ribbon button, that will copy values that have already been selected by the user, in either columns C,D or E and always paste them in column B. See table below for an example. The user selects cells 1, 2 and 3 of data in col C and runs the...

Hi Everyone. I pull multiple reports from the same source and they are all built (same number of columns & same headers) identically. Only the data is different. Obviously I can copy them, go to the very bottom of the first workbook data, and paste in the first row. That was fine where there...

I’m creating a macro so I can click and drag down a formula X rows. The formula contains reference cells in another excel file that automatically increment. This is what I want. When I run the macro, the cells keep incrementing past what the original formula increments to. How do I repeat...

I am new to macros and am having trouble creating a macro that will copy a range of cells and then paste just the values back into the same cells. Basically I just need to get rid of the formulas and paste the value back into the same location. I have tried the coding below, but I am getting an...

I have a master commission sheet that has every salesperson with the invoices they get commissioned on. Each individual also has their own individual spreadsheet that has their information along with some personal targets and other information. In the master commission sheet, I have the...

Hey new to macros. My issue, I want my macro to loop through a number of cells on sheet1 and then transfer the entries into specific cells onto sheet2. On sheet2 column A, I want specific headings to be printed based on whether or not the values in sheetA1 are different. Visual aid: Sheet 1...

I have sheet 1 from column A until column AW, or until count, different rows, to copy to another sheet with macro., in only one column . Sheet 1 Row A1 = 1, have to copy to sheet 2 Column A and Column B

Hello, I'm currently having such a big backlog at work after a covid outbreak on our department and the pile keeps on increasing and increasing, despite already working 10 hours per day on average. There are so many manual acations required before an invoice can be processed, that I can't catch...

I have a master workbook that I need to update 4 sheets daily (Data A, Data B, Data C, Data D) I get the data workbook and worksheet name differently each time so I change it manually in order for the code run that copies the first sheet of the workbook on a specified folder so I need to change...

Hello, So I have tried solving this problem, but I just cant come up with a solution. I have 2 files (see attached). Master File and a template. I need a macro that copies data from the Masterfile columns per row to the template and then save it with a new file name lets say "Template-110122"...

I hope everyone is having a wonderful new year so far. I'm really struggling with a macro I'm trying to build and I hope I can get some advice here :) I have a sheet (called: "Motors") with 24720 rows. I'm trying to fill empty ranges with different intervals in column A and B with the values...

The intended effect: The code filters the table (Table1) on Sheet("AutoCensusReport") according to the EditLine# autofilter conditions. Then, if there are any rows that ARENT hidden it selects the unhidden cells that aren't blank in range A and pastes them in the first empty cell in range A on...

Hi all, I'm having an Excel and I want to create a list of all unique values in Column A and B and copy them to a new sheet. This is my current Excel: This is my code: Sub CreateUniqueList() Dim lastrow As Long Dim ws As String ws = ActiveSheet.Name Sheets.Add.Name = "mysheet"...

Hey All, I am having major difficulties working out a macro formula for what I am trying to do, unfortunately, this seems way, way more advanced than my current skillset, and I can't seem to find any good video tutorials on what I am trying to do. I am trying to create a macro with a button...

Hi guys, I'm trying to find a way to copy a range from and until a cell contains the specific text "Total". L1/2 are the header, so the data should begin copying at L3:Q for the blue background. However, I want to stop copying once it reaches "Total". I'm currently just being thrown errors and...

i have two sheets with two columns 'broj' i must compare those column and if i find matching values, cells from sheet 2 copying in sheet 1. like example i have sheet 1 ABCDEFGHIJ1brojkorisnikbanka...

Hello Gurus, I'm getting a syntax error on this part of my code. Anyone who can help me tweak the code below? = = = = Sub Check With Range("Z2") .Formula = "=IF(Z2<0,"Less",IF(Z2>0,"Add",IF(Z2=0,"Zero")))" With .Resize(Range("A" & Rows.Count).End(xlUp).Row - 1)...

Hello, Im new in VBA, and im searching for a script that would search in multiple sheets within one woorkbook, for specific text (specified in script itself) and paste it in a new sheet. for a descritpion: - multiple sheets (search in all of them) - skip new reference sheet + few others...

Hi there, I’m hoping that someone can help with this query. I am very new to VBA so apologise in advance if the answer here is obvious. I am trying to achieve the following: Create a macro that can be assigned to a button (in the simple form of a shape) that can perform the following two...