S Sam Oct 1, 2003 #1 Is there something in Excel that you can compare contents of one Excel file with another file and output the differences?
Is there something in Excel that you can compare contents of one Excel file with another file and output the differences?
D Dave Peterson Oct 2, 2003 #2 Myrna Larson and Bill Manville have developed a compare that's very nice. http://www.cpearson.com/excel/whatsnew.htm look for compare.xla But the bad news is that this does a cell-by-cell comparison. A1 compares to A1, x99 to x99, etc. If you insert/delete a row or column, then this won't work very well.
Myrna Larson and Bill Manville have developed a compare that's very nice. http://www.cpearson.com/excel/whatsnew.htm look for compare.xla But the bad news is that this does a cell-by-cell comparison. A1 compares to A1, x99 to x99, etc. If you insert/delete a row or column, then this won't work very well.
