Compare Single Field In Two Excel Files, Create Dif File (1 Viewer)

[Kheribus]

Hello,

I have the need to take two demographic files (personal info - address/city/state/details/etc...) and create a dif excel file from them.

File 1: Demographic updates over the last x days (probably 2/3 days) - Probably no more than 2/3k records.

File 2: Comprehensive demographic file - all current records (120k).

Basically, I want to create a new file that contains all records from file 1 wherean address (column J) has been updated from file 2 to file 1.

For each record in file 1 (identified by unique ID in column A), I want to find that record in file 2 and compare the address field (column J). If column J is different in file 1 than it is in file 2, I want to write that entire record's line from file 1 into a new document.

What would be the best way in VBA to accomplish this?

Thanks in advance!

 

[Ranman256]

vba not needed. Create an outer join query to check the 2 tables. It will show the difference.

 

[Kheribus]

What if file 1 and file 2 are not exactly the same (not all fields from file 1 are in file 2)? I just want to compare a single field from file 2 to file 1. Attempting this now, though, thanks.

 

[Kheribus]

Nevermind this should work by setting the join criteria. Thanks.