Merging 2 files
 

I have an attendee list for a tradeshow so each line contains name, address,
phone number, etc....

I just received an updated list but I had done some work on the first list.
How do I merge the second list into the first or vice versa. I don't want to
lose what I did on the first list and I want to eliminate duplicates.

Please help. Thanks.

Merging 2 files
 

Suppose you have worked on Sheet 1 and get the new data in Sheet 2 (You can
paste from the new workbook to sheet 2 or point to the new workbook by
changing the formulae below)
Suppose both sheets have names in Col A to match
In Sheet 2 in any blank column enter this
=VLOOKUP(A1,Sheet1!A:A,1,False) and copy down
Whereever you get #N/A are the new names on sheet 2 you can filter on #N/A
select and paste on Sheet 1...

"Distribution list - Contacts Module" wrote:

I have an attendee list for a tradeshow so each line contains name, address,
phone number, etc....

I just received an updated list but I had done some work on the first list.
How do I merge the second list into the first or vice versa. I don't want to
lose what I did on the first list and I want to eliminate duplicates.

Please help. Thanks.