Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Comparing Workbook contents
In Excel 2002, how do I compare contents in different workbooks and identify
the differences? |
#2
|
|||
|
|||
Myrna Larson and Bill Manville have developed a compare that's very nice.
http://www.cpearson.com/excel/whatsnew.htm look for compare.xla But the bad news is that this does a cell-by-cell comparison against two worksheets--not workbooks. A1 compares to A1, x99 to x99, etc. If you insert/delete a row or column, then this won't work very well. ======= Other alternatives that may work depending on what kind of differences you're looking for: Save each worksheet as a .csv file and use any comparison program you want to compare two text files--like MSWord. SMC wrote: In Excel 2002, how do I compare contents in different workbooks and identify the differences? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy a workbook from other workbook with lot of sheets wit... | Excel Discussion (Misc queries) | |||
Resize the workbook window is impossible | Excel Discussion (Misc queries) | |||
Creating a subbook from a workbook. | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
How do Icreate link from page of contents to sheets in workbook? | Excel Discussion (Misc queries) |