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
....