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

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



" wrote:

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