Want to copy sheet1 data to sheet2

[Closed]
Report
-
Posts
1316
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
August 21, 2021
-
Hello,
hi there
i am just new to excel and iam trying to understand by praticing by own
i want to copy sheet1 data to sheet2 when im typing in sheet1
thanks


1 reply

Posts
1316
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
August 21, 2021
237
Hello Naseer,

As a starting point, here is a basic code that you can try for copying data from sheet1 to sheet2:-

Sub MoveIt()

Worksheets("Sheet1").Range("A1").EntireRow.Copy Worksheets("Sheet2").Range("A" & Rows.Count).End(xlUp)

End Sub



You will need to enter this code into a basic module and then run it from there.
I hope this helps.
Kind regards,
vcoolio.