Where do I start......

I have 2 excel spreadsheets with naes and addresses on them.

1 from 2004 and 1 from 2005

the 2005 one has names on it that the 2004 one doesn't can I merge or something similar to let me know whats on the 2005 one that ISNT on the 2004 one to save posting letters to people we have already sent to?????

help would be much appreciated


paul

 

Hi Paul,

easiest way that I personally think is to save each sheet as a csv file so you have 2004.csv and 2005.csv.

Once done, create a new Access DB and and import both of the above CSV files into one table. Ensure you have no primary key set for this table. There's help available in Access to create a "remove duplicates" query. You may need to import one csv file into a table first, set a primary key for the field with possible duplicate info, ie. names or postcode and then import the second csv file into the same table. Access will give you an error saying it couldn't add x records due to primary key violation - voila ! job done

Apologies if this doesn't make sense but I'm hoping it will.

I'm also pretty sure that Excel has a duplicates function but you'll need to add the content of sheet 2 to sheet 1 so it's all listed together.

cheers, Jai

 

VLOOKUP could help identify the ones that aren't in one side
Or as above just paste one below the other, select the column and do Data... Filter... Advanced Filter... and check the Unique Records Only box.