Posted by Thomas Venn on February 03, 2000 12:08 PM
Hi, Is there any way to trace dependents, and actually "know" where the dependent cells are?
For example, in cell B5, the formula is A1+B2+C3,
and in cell B6, the formula is A1+B2+C1
What I want to do is, when I want to trace what cells are dependent on cell A1, it would be cell B5 and B6. I am already familiar with the Auditing Toolbar, but that does not work when it is 2 seperate sheets, additionally, I would like to be able to write down the dependent cells instead of looking at arrows.