View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
THT THT is offline
external usenet poster
 
Posts: 7
Default Tracking changed cells in two identical worksheets

Hi,

I have two worksheets with the same columns. File 1 is my master sheet with
all my rows of data, while File 2 contains only specific rows in File 1. For
example,

File 1 (1000 rows)
Name... City... Age... Group

File 2 (20 of the 1000 rows)
Name... City... Age... Group

File 2 has the most up-to-date data for the 20 of the 1000 rows. Can I
update the data from File 2 into File 1 (for changed cells only) by using a
macro?

I'm not too familiar with VBA code.

Thanks in advance for your help!