PDA

View Full Version : Solved: Copy the latest row of sheet A to another sheet



parscon
03-21-2012, 12:05 PM
I need help .
I have some data in sheetA and also i have some data in SheetB now i need a macro that can copy the latest row of sheetA to latest blank row of sheetB .

Thank you so much .

Kenneth Hobs
03-21-2012, 12:37 PM
Worksheets("Sheet1").Range("A" & Rows.Count).End(xlUp).EntireRow.Copy _
Worksheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1)
Application.CutCopyMode = False

parscon
03-21-2012, 01:34 PM
Thank you so much