Hello:

Iam trying to compare several columns on two sheets.

For example compare all the contents of column A,B,C,D on sheet1 with
the corresponding columns A,B,C,D on sheet2. Once it runs the
comparison, all cells which do not contain the same corresponding
values (ex sheet1.cell(a1) and sheet2.cell(a1)) will be colored yellow.
A Message box would also appear telling how many incorrect matches have
been found.

Please can someone help me
Thank you

Also could such a macro be used on more than two sheets simultaneously.


--
kwedde01
------------------------------------------------------------------------
kwedde01's Profile: http://www.excelforum.com/member.php...o&userid=24156
View this thread: http://www.excelforum.com/showthread...hreadid=386563