Exec Help! Copy data that can be updated

Closed
Excelknow - 22 Nov 2009 à 16:02
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 22 Nov 2009 à 22:02
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 response

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
22 Nov 2009 à 22:02
try this code (modify to suit you)

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