MrExcel.com - Your One Stop for Excel Tips & Solutions

comparing two excel files

Posted by john niolon on December 03, 2001 6:00 AM

I have two files that contain records of property ownership with names and addresses.. One is the master and the other is a file that shows all parcels with new owners names (if any) .

I need a way to compare the two files to find updates and only change those records that have been updated and make those changes in the master file. The files are between 3000 and 4000 records.

thanks

John Niolon

Posted by Joe C on December 03, 2001 6:32 AM

I would use VLookup.
Sometimes when I have alot of records and columns, I will make one column of the report I am going to take info from the same as the row #. I then Vlookup that column only. Then I use that columns value(which is the row# for the corresponding record) in a short VBA program to update whichever records need to be in the final sheet.