Exec Help! Copy data that can be updated

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

How do you copy a list into a second sheet in excel, so that if you update the data in the original list on the first sheet, it will automatically make the updates to the copy of the list in the second sheet. Would really appreciate the help! Thank you

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
try this code (modify to suit you)

Worksheets("sheet1").UsedRange.Copy Worksheets("sheet2") _
    .Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)