Z zyx777 Aug 21, 2003 #1 Is there a formula or macro so I can compare all cells of Wsheet1 with Wsheet2 and tell me what cell has a difference ?
Is there a formula or macro so I can compare all cells of Wsheet1 with Wsheet2 and tell me what cell has a difference ?
H Hank Scorpio Aug 21, 2003 #2 Is there a formula or macro so I can compare all cells of Wsheet1 with Wsheet2 and tell me what cell has a difference ? Click to expand... 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
Is there a formula or macro so I can compare all cells of Wsheet1 with Wsheet2 and tell me what cell has a difference ? Click to expand... 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