Merging Excel Files into one.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have Excel 2002 and several Excel spread sheets of addresses I want to combine into one but they have a lot of the same data which I do not want to replicate....how can I merge them and they do not put the same address twice but just keeps one of all?

Thanks,

Tavis
 
Tavis

Copy all to one worksheet then deal with the duplicates by filtering.

1. Copy all to one worksheet.
2. Insert a blank worksheet.
3. Select your full range on address sheet then go to Data>Filter>Advanced
Filter.
4. Check "Unique records only" and "copy to a new location".

Your "listrange" will be already entered. In the "copy to" click on the
Collapse Dialog button and select your new worksheet A1.

OK your way out.

Gord Dibben XL2002
 
Hey again. Thanks for your reply. I tried copying and pasting the information from both files into one new excel file and then sorting then information but it still puts duplicate copies in the file if you sort the information by last name. Is there anything else that can be done? Thanks

Tavis
 
Kind of the same technique that Gord suggested:

I'd create a third worksheet.

Copy the key values from both worksheets into a giant list (column A).
Use Data|filter|Advanced Filter to extract the unique entries
Debra Dalgleish has notes at:
http://www.contextures.com/xladvfilter01.html#FilterUR

Plop that unique list right into column B of the new worksheet. Then delete
column A that has all the duplicates.

Then use a bunch of =vlookup()'s to return the individual fields from the
original workbooks.
 
Back
Top