Compare Sheets 1.1.2

Compare two tables created with MS Excel and creat result table containing rows from first table that have or haven`t equivalent in second table according to given criteria.

Tested on Windows 7, and works in same way as on any other windows OS.

You do not need MS Excel or any other software that opens MS Excel files in order to use Compare Sheets.
You can review comparision result by opening file in Compare Sheets and selecting sheet containing result

How to prepare tables for use with compare sheets:

• 1.create new workbook
• 2.select original first table from your existing workbook including column headers, then copy selection, then go to new workbook sheet1 and use paste special to paste values
• 3.do the same for seconf table but paste special in sheet2
• 4.adjust columns headers if necessarry to make them identical
• 5.save new workbook with name you want as "excel 97-2003"
• 6.open new workbook in cs.
• 7.type file name in field "Result file" to have result in separate file or live it blank to have result sheet added to current file
• 8.compare tables

 

 

 

Related softwares