Exec Help! Copy data that can be updated

Closed

Excelknow - Nov 22, 2009 at 04:02 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 22, 2009 at 10:02 PM

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

Exec Help! Copy data that can be updated
Tmobile data check - Guide
How to be offline in whatsapp when data is on - Guide
Transfer data from one excel worksheet to another automatically - Guide
Data transmission cable - Guide
Spectrum data usage - Guide

1 response

Answer 1 / 1

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 22, 2009 at 10:02 PM

try this code (modify to suit you)

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

Similar discussions

AMD data change update new data to DMI

Unlock safe folder without losing any data

How To Fix Mint Mobile Data Not Working?

Hosted app data will not clear

Messenger missing emojis

Similar discussions

Subscribe To Our Newsletter!