Discussion Locked
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 tuckerlv
The question was auto-closed by TechRepublic
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
by tuckerlv
The question was auto-closed by TechRepublic
by tuckerlv
This question was auto closed due to inactivity
This discussion is closed to new replies.
Trending Desktop posts
Sort by Trending
Discussion
How to make light speed agent go away
0 helpful
4 replies
Question
Floppy drive wont work on my 486
0 helpful
1 reply
0 helpful
1 reply
Discussion Locked
Ryzen 7 7700
0 helpful
2 replies
Question Locked
Issue fully resetting my PC
0 helpful
4 replies