Updating fields


Posted by Mark on February 07, 2001 8:40 AM

I have a data base in sheet1. In sheet2 I can get the latest changes for some of the data. I want to update only records with new data in sheet1 and add new records to sheet1 if they appear in the new data sheet2. Once the how is determined, I'll make a macro to do it automatically. Thanks.



Posted by tom venn on February 07, 2001 4:38 PM

how about adding an extra column in sheet 2, then do a vlookup in sheet1 against sheet2. if your vlookup is not #N/A, then it is data which has changed.

cheers,

tom