Want to copy sheet1 data to sheet2

Closed
NASEER - Jan 30, 2015 at 07:09 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Jan 30, 2015 at 06:55 PM
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


Related:

1 response

vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 262
Jan 30, 2015 at 06:55 PM
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.
0