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

[Solved/Closed]
Report
Posts
3
Registration date
Saturday May 24, 2014
Status
Member
Last seen
May 26, 2014
-
Posts
3
Registration date
Saturday May 24, 2014
Status
Member
Last seen
May 26, 2014
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
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
Posts
3
Registration date
Saturday May 24, 2014
Status
Member
Last seen
May 26, 2014

So Nice of You