CODEWITHSUNDEEP
vbaexcelreferenceexcel-formula
Nick Ginanto
Nick Ginanto

Reputation: 32130

finding out the referenced value of a cell in excel

I have an excel file with several worksheets

the worksheet is littered with formulas in each cell which reference cells in other worksheets such as:

in WS1 in cell A1 it has =+WS2!B2

in WS2 in cell B2 it has =+WS3!C3

and in C3 it says =D4*50

Is there a way to have cell A1 in WS1 to be =D4*50 ? or atleast show that to me?

The closest I could do is click on Evaluate Formula which will traverse through the reference and cells

enter image description here

Is there something like this but for many cells?

Upvotes: 0

Views: 119

Answers (1)

Kamal G
Kamal G

Reputation: 278

On Formula tab, Trace Dependent and Trace precedents can help you..

Upvotes: 2

Related Questions