I have a sheet that is testing amounts from different sheets. It is linking
to different sheets where the amounts should be the same and then in the
controlfile.xls I test the value from the link to see if they are equal. I
have about 100 tests to be perfomed. The thing is it is too difficult to
tell if the links are pulling from different cells as they should or if the
user accidentally used the same reference in their compairison. For Example
in ControlFile.xls

Cell B10: =File01.xls!G30
Cell B11: =File04.xls!D10

In cell B10 I see 250.00 and in cell B11 I see 250.00 and the comparison in
Cell C11: B10-B11 results in -0- which is good. But how do I know for sure
the user did not actually use the same formula in B10 and B11. There are too
many review the formulas manually.

Thank you,

Steven