Cell by cell?

A1 with A1, Q12 with Q12, AC232 with AC232?

If yes, then you could use a program written by Myrna Larson and Bill Manville.

You can find a copy on Chip Pearson's site:
http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla

Rich wrote:

Hello,
Does anyone know how I can compare two seperate tabs of data and show
only the exceptions on a seperate tab? I am comparing data on two tables and
only need to know which ones don't match.

Thanks,

--

Dave Peterson