Merging excel documents

[edward fagbemi]

I have 2 Excel 2000 documents and I have been trying to
merge. They are in two different workbooks.One is a master
file and the other a secondary file.I need to match on
similar fields, 2.display records that are only unique to
the secondary file.3.Display records that are only unique
to the master file.

Thanks

 

[Bernie Deitrick]

Edward,

If your workbooks have similar structure, insert a new column A for
each of them, and put the workbook name into column A, all rows. Then
copy all the data, including column A (but no headings) from the
second workbook and paste it at the bottom of the data from the first.

Then you need to identify repeated data: is that based on one field,
some fields, or all fields being the same? In another column, use a
formula like
=B2&C2&D2
to concatenate the fields that determine similar records.

Let's say that formula is in column M. In cell N2, use the formula
=Countif(M:M,M2)
and copy that down to match your data.

Then apply a filter, and filter based on column N being 1 and column A
being the first workbook, and then again for the second workbook, and
you will have identified the data unique to each. Note that this
technique will not show duplicated data that is unique to one
workbook.

HTH,
Bernie
MS Excel MVP