I am trying to copy data from a column in a worksheet, and paste it into column “A”, at the bottom of a data set in another worksheet (“Final Report”). So there will be a bunch of data, then a title bar, then I want the copied data to be pasted in column “A” underneath the title bar. Both worksheets are in the same workbook.
I have the filtering and copying down, just need to know how to get the cursor to paste the data in the proper place.
Below is what I have so far:
![]()
ActiveSheet.Range("$A$1:$JE$1332").AutoFilter Field:=57, Criteria1:="=” ActiveSheet.Range("$A$1:$JE$1332").AutoFilter Field:=85, Criteria1:="=" lr = Cells(Rows.Count, 1).End(xlUp).Row With Range("U2:U" & lr) .SpecialCells(xlCellTypeVisible).EntireRow.Copy ActiveSheet.Range("A" & Rows.Count).End(3)(2) End With Sheets("Final Report").Select ....
Bookmarks