Comparing 2 worksheet

zyx777 · Aug 21, 2003

Is there a formula or macro so I can compare all cells of Wsheet1 with
Wsheet2 and tell me what cell has a difference ?

Hank Scorpio · Aug 21, 2003

Is there a formula or macro so I can compare all cells of Wsheet1 with
Wsheet2 and tell me what cell has a difference ?

There's a useful add-in by Myrna Larson and Bill Manville that will do
that for you. You can find it here:
http://www.cpearson.com/excel/download.htm