Merge 2 excel worksheets into one and remove duplicate entries.

[jehegarty]

I need to take 2 seperate Excel worksheets with similar data, and
merge them into one Worksheet and remove all duplicate values leaving
only one of the duplicate entries behind. EXAMPLE: Sheet 1 has 1234
and 2345, sheet 2 has 1234 and 4567, the merged sheet needs to show
1234, 2345 and 4567 with only 1 entry for any duplicate that is found.

These worksheets will have a few thousand entries each, with one or
more common columns.

Basically I have 2 inventory lists, with similar info, I need them
merged and duplicates removed leaving only 1 item each and also any
unmatched (or non-duplicate) items.

Clear as mud? I have found a way to import this information into
Access but that only gives me the matched items, the unmatched items
are removed.

Thanks in advance

 

[Guest]

If the data is in Access, in either 1 or 2 tables, you can very easily get
what you want.

If in 1 table - tell Access you want Unique Records (right click in the
Query pane to the right of the tables to show the Query Properties - look in
that panel for Unique Records)

If in 2 tables, then create a query to insert the values from one table into
the other. When that is done, follow the steps above for a single table