Why not copy 2008 info to 2009sortrun a macro to compare from the BOTTOM
up deleting rows that match.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dude" wrote in message
...
I have 2 workbooks with contact information as follows;

company address city state zip phone
contact
123 co. anystreet anyttown tx 12345 (123)456-7890 joe
smith

One is the 2008 listing, and the 2nd one is the 2009 listing.

Both lists contain over 200k entires.

I need to compare the 2, and delete all duplicate entries in the 2009
list,
leaving only the new additions in 2009 to work with.

Is this possible in excel, or do I need to get Access now?