You can use that feature for workbooks that are copies of the same
shared workbook, and each must contain a change history. For details,
look for 'Merging workbooks' in Excel's Help.


Dan Powell wrote:
I have two Excel files which I want to Merge together on the cell PatientID
into another Excel file (Starting Empty). The tool box has a command 'Compare
and Merge Wookbooks' but is greyed out.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html