Need vba Code to Transfer Data from Sheet3 to Row1 of Sheet2?

Solved/Closed
hmk950 Posts 3 Registration date Saturday May 24, 2014 Status Member Last seen May 26, 2014 - May 24, 2014 at 12:34 AM
hmk950 Posts 3 Registration date Saturday May 24, 2014 Status Member Last seen May 26, 2014 - May 24, 2014 at 07:52 PM
Hi dears,
I need a VBA Code which can transfer the LAST ROW's (ie 15 or 29 or may be any other) Data of Sheet 3 to ROW 2 of Sheet 2 . Reason to Transfer the Data is to get done the printing Job in a receipt and later clear the Row 2 of Sheet 2 each Time when printing Done.
In Advance B O T (Bundle of Thanks) to all Friends.

HMK

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
May 24, 2014 at 07:10 AM
is this what you wat

Sub testg()
With Worksheets("sheet3")
.Cells(Rows.Count, "A").End(xlUp).EntireRow.Copy
With Worksheets("sheet2")
.Range("A2").PasteSpecial
End With
End With
End Sub
0
hmk950 Posts 3 Registration date Saturday May 24, 2014 Status Member Last seen May 26, 2014
May 24, 2014 at 07:52 PM
So Nice of You
0