Merging workbooks that weren't "shared workbooks"

[K. Georgiadis]

I've got a problem in that one person in the
organization, working independently, has been making data
changes in an older version of the workbook (note that
this was NOT a shared workbook). He happens to be the
boss, so that his changes must be adopted.

I have been asked to merge his data changes into the most
recent version of the workbook. I fear that Excel's merge
function would not work here and that I'll have to resort
to the good ole' cut 'n paste technique. Any other
suggestions?

 

[Frank Kabel]

Hi
you may have a look at

http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla
(http://www.cpearson.com/Zips/Compare.ZIP)

This should highligt the differences but it will be still some manual
work...