merge two files with replacements

jniolon · Feb 22nd, 2002, 08:52 AM

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 · Mar 21st, 2002, 08:59 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 22nd, 2002, 08:52 AM	#1
jniolon New Member Join Date: Feb 2002 Posts: 9	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

Mar 21st, 2002, 08:59 PM	#2
Corni Board Regular Join Date: Mar 2002 Location: Brampton Posts: 324	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.