The add-in, Compare.xla written by Myrna Larson and Bill Manville, allows
you to compare the contents of two workbooks and highlight differences.

http://www.cpearson.com/excel/whatsnew.htm

Look for Compare.xla at 14-June-2000

Download Compare.ZIP, unzip Compare.xla and add it to your Office\Libray
folder.

On Tools Menu, select add-ins and checkmark Compare Worksheets.
From tools menu then select Compare Sheets and follow instructions.


Gord Dibben Excel MVP




On Fri, 17 Oct 2008 11:47:01 -0700, LeeAnn
wrote:

I need to compare two Excel documents and list out the differences between
the two. I did not find any Out of the Box (OOTB) capability in Excel to do
this. Are you aware of any 3rd party OOTB tools that will provide this
capability?

-Thanks