General discussion

Locked

Excel 2000 Spreadsheet Comparison

By tuckerlv ·
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.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel 2000 Spreadsheet Comparison

by SridharPandu In reply to Excel 2000 Spreadsheet Co ...

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

Collapse -

Excel 2000 Spreadsheet Comparison

by tuckerlv In reply to Excel 2000 Spreadsheet Co ...

The question was auto-closed by TechRepublic

Collapse -

Excel 2000 Spreadsheet Comparison

by carquiza In reply to Excel 2000 Spreadsheet Co ...

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

Collapse -

Excel 2000 Spreadsheet Comparison

by tuckerlv In reply to Excel 2000 Spreadsheet Co ...

The question was auto-closed by TechRepublic

Collapse -

Excel 2000 Spreadsheet Comparison

by tuckerlv In reply to Excel 2000 Spreadsheet Co ...

This question was auto closed due to inactivity

Back to Desktop Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums