Can you copy both sheets onto a new one, sort them by Last name? look at the
duplicates and choose the data you want, combine some data, and delete the
others. This keeps both originals in place until you decide if this working
copy will be your final product.

"Stella" wrote in message
...
I have two worksheets with similiar data, ie. name, address, city, state,
zip
code, phone numbers.

I need to merge these two files. I would like to have duplicates deleted
and have similiar and new data identified in some way.

Is this possible? I am a beginner user with Excel and am not familiar
with
programing, etc.

So responses should be kept fairly simple.
--
Thank you.