I have multiple data bases in Excel I want to use for labels in mail merge
but I want to combine the data bases and remove duplicates. the compare &
merge workbooks under "tools" is greyed out.

Phil

Compare and Merge is only available if the workbook is shared and you want to
merge multiple versions of same workbook.

See help on "merge workbooks".

Can you copy/paste all from workbook B to workbook A?

Then DataFilterAdvanced FilterUnique records and copy to a new location.


Gord Dibben MS Excel MVP


On Fri, 15 Sep 2006 16:13:01 -0700, Phil wrote:

I have multiple data bases in Excel I want to use for labels in mail merge
but I want to combine the data bases and remove duplicates. the compare &
merge workbooks under "tools" is greyed out.