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.
|Check out our Excel Resources|
Locate cells in another worksheet or workbook that provide data to a formula
If the reference you want to locate is in another workbook, you must first open the other workbook.
1 Display the Auditing toolbar by pointing to Auditing on the Tools menu and then clicking Show Auditing Toolbar.
Before you use the Auditing toolbar, make sure Show all or Show placeholders is selected under Objects on the View tab in the Options dialog box (Tools menu).
2 Click the cell that contains the formula.
3 To display a tracer arrow to each cell that directly provides data to the active cell, click Trace Precedents on the Auditing toolbar.
4 Double-click the arrow that displays the worksheet icon and points to the active cell.
5 In the Go to box, click the reference you want to go to.