Merging Excel Files into one.

T

Tavis

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
 
G

Gord Dibben

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
 
T

Tavis

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
 
D

Dave Peterson

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.
 
Top