merge two files with replacements

[jniolon]

I have two excel files. One is a master name and address listing. The other is a list of corrections to this list that are received periodically. There is a key field that is identical in both files. Is there a routine that would match records based on this key field and replace the old records with the updated ones.

I'm looking at a file size of around a thousand records in the master file and up to a couple of hundred on the update file...

Thanks
John Niolon

 

[Corni]

Use a Workbook_BeforeClose event procedure for the update file, which will open the master file, match the records with updates (use worksheet function Match) and replace the old values for name/address with the corresponding values from the update file.