Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Workbook Compare utility
Hi Excel newsgroup peers:
I've been away for a while, busy working on a utility which is complete and is downloadable on my website. The utility, which I originally wrote for my consulting work, is an Excel data comparison tool called (simply enough) Workbook Compare. There is a free version which I published early last year available. There is also a shareware version with more extensive features. Basically, the idea is that you can extend an Excel solution, add new columns, move columns around, optimize formulas, insert headers/shift data tables down, and then compare that to the last production version to validate that the new version produces the same numbers. The utility automatically "maps" the workbooks being compared, making comparisons very easy. It spits out an Excel report of the differences with extensive metadata to provide a deep context of the differences. If anyone would like to try the free version, feel free to download it and any feedback you have is much appreciated. The shareware version has more extensive features such as unique key indexing, highlighting of differences, as well as many other helpful features for those of us who "live in Excel" and need to validate their work. Thanks Tim Zych -- Tim Zych www.higherdata.com Compare data in Excel and find differences with Workbook Compare The most flexible workbook comparison tool available Free and Pro versions available |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare workbook | Excel Worksheet Functions | |||
how to compare 2 worksheets in 1 workbook | New Users to Excel | |||
compare.xla utility | Excel Discussion (Misc queries) | |||
How can I compare worksheets in the same workbook? | Excel Discussion (Misc queries) | |||
Q: compare and replace in a workbook | Excel Worksheet Functions |