Discussion Locked

Excel 2000 Spreadsheet Comparison

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Do you have a utility that will compare each row in two spreadsheets and output a third spredsheet of the rows? The output options are: 1. The contents of first spreadsheet is copied to the third spreadsheet cell by cell in each row so that the cells that are differences are highlighted in a preset color. 2. The contents of second spreadsheet is copied to the third spreadsheet cell by cell in 1 & 2 except that only the rows with cells that are different will be highlighted in a preset color& output into the third spreadhseet. The input spreadsheets are more than 20k to 40k rows with 10 to 30 columns in length. Some spreadsheets are 10 times more rows. I do not have any options to receive this data in another format. The Vendor only outputs Excel xls format. The end user must attempt to validate the accuracy of the data by reviewing every line/ros.

5 replies

by sridharpandu

Hey its easier to write a macro. If you can tell me whether the rows in the 2nd sheet should be compared to the same row in the first sheet or should it be compared to every row in the first sheet, I should be able to write a simple macro for u.

Best regards

by carquiza

You can find your answer to this web site:
http://www.mrexcel.com/wwwboard/wwwboard.shtml
Hope this help a bit.

Cheers,

Mel Arquiza
Home Page Design
http://hpd.welcome.to

This discussion is closed to new replies.