B Billy Washam Jul 31, 2003 #1 What is the best way to compare two versions of a work sheet to determine changes that have been made?
What is the best way to compare two versions of a work sheet to determine changes that have been made?
D Dave Peterson Aug 1, 2003 #2 Have any rows been inserted or deleted? Same for columns? If none have--just data has changed, then Myrna Larson and Bill Manville have written a comparison program that does a cell by cell comparison (a1 with a1, x99 with x99). You can find it at: http://www.cpearson.com/excel/download.htm Look for Compare.
Have any rows been inserted or deleted? Same for columns? If none have--just data has changed, then Myrna Larson and Bill Manville have written a comparison program that does a cell by cell comparison (a1 with a1, x99 with x99). You can find it at: http://www.cpearson.com/excel/download.htm Look for Compare.