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.
current version: 1.1.2
interface: english
OS: Windows all (require at least IE5, 1024x768)
date: 2011.09.29
autor: Ventsislav Alexandriyski
license: free
size: 532KB
license: free
What is new in version 1.1.2---fixed problem that prevents comparision of tables that have spaces in names and names of fields
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
Awards:
Computer software
Mobile Fun
