Merging data from different worksheets

Thank you, starguy. I'll try it out and let you know how it works.

That worked wonderfully! Thank you for your help!!!

My setup is similair to this but different in a few ways.

Columns are setup as such:
A is first name
B is last name
C is physical addresss
D is city
E is State
F is Zip code.

Generally I will sort the data by column B and manually select any duplicates however my database has gotten rather large (2000+ rows) and we are constantly incorporating new addresses into our database. Obviously I want to be able to check when I merge a seperate mailing list to see if there are any duplicates and delete them based on last name, and address. (first name sometimes varies but still retains the same addresses)

I work for a Non-profit organization and we are constantly adding new donor lists to our database.

Any help is greatly appreciated. I'm using primarily excel 2003 but do have access to Excel 2007

Why wouldn't starguy's solution work for you?