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