lastrowa

Hi I have a spreadsheet which has over 1000 lines, all for varying companies. What I would like to do is create an option so when you run it, it will copy the relevant lines to their respective sheet. The code listed below is some I have seen on here, which works to a point. It will run for one...

Hello I have the following code which copies from one sheet and pastes from Row 8 in the next. Each time I run the macro it copies over, I would like to change it to append the data. Any thoughts, thanks. Sub Add_to () Application.ScreenUpdating = False Dim i As Long Dim Lastrow As Long...

Hello Mr Excel :smile: Could someone tell me how to write VBA code of filtering data without activating the sheet to delete my rows. Here is my code below Dim LastRowA As Long LastRowA = Sheets("QRU").Cells(Rows.Count, 1).End(xlUp).Row Worksheets("QRU").Activate...

Hi, I made this macro and get an error on this line Worksheets("Temp").Range("A1").SelectI run the macro from the sheet Q-Simple. I dont know why there is this error because if I select the sheet, than that means it is activated... so why this error. It is so basic... Please give me a clue...

I have a workbook with multiple worksheets - sales of different companies for different months. The worksheets have the same columns. Different number of rows 1000 - 60,0000 I am attempting to copy data from these worksheets to multiple other files(each having a single worksheet- one company in...

L.S., I am trying to populate column P with a formula that exists in cell P5. The number of rows is variable and is dependent on the number of rows in column A. As column P is pre-populated, it might be longer or shorter than column A before running the code. It should end up with the same...

Hello, I have this code working. Range("A2").Select Selection.FormulaArray = _...