This copies last row and everything above it but I only want to capture the last row; how do I fix this (or if there's another method altogether, I'm good w/ that too!)
Need help knowing how to paste it into Sheet 2 of a different workbook too as this only puts it into Sheet2 of same workbook.
Other workbook would be found here: c:/users/me/Documents/Reports/MasterReport.xlsm (Sheet2)
I can either have both open at same time when I hit RUN or I can keep the MasterReport closed if that's easier -- whatever is easiest to script..
Sub CopyLastLinetoNewSheet()
Sheets("Sheet1").Range("A2:T" & Cells(Rows.Count, "A").End(xlUp).Row).Copy Sheets("Sheet2").Range("A1")
End Sub
Thank you
Bookmarks