I deal with Workbooks/Worksheets in which I need to compare the previous
version of a WB/WS with the newer version, particularly for differences in
formulas. The Worksheet layouts from one version to the next are the same
(contents of the physical rows and cols), but when the formula changes for a
particular cell, I would like to show the difference on a 3rd worksheet.

For Example:

I have the following input WS's that I would like to analyse for formula
differences that I want to display in a third WS (Sheet3)...

Sheet1 with Cell A1's Formula=SUM(B1,B2)
Sheet2 with Cell A1's Formula=SUM(B1,B2,B3)

And I would like to produce Sheet3...

Cell FormulaSheet1 FormulaSheet2
A1 SUM(B1,B2) SUM(B1,B2,B3)

Any generic algorithm is appreciated. Thank you.


John Claussen