Want to copy sheet1 data to sheet2

Closed
NASEER - Jan 30, 2015 at 07:09 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - 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


1 response

vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 259
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