How to get formulas starting from the referenced cells

  • Thread starter Thread starter Dario
  • Start date Start date
D

Dario

Hi all,

I've cells on a sheet which are referenced by formulas which are on
different sheets (about 20) on the same workbook, and I'm looking for
a way to get all these formulas. I've tried:

1) The Trace command, but I see only a table icon every time I've this
type of reference
2) The Find command, but there are cell references wrote in different
manners (ie B2, $B2, B$2, $B$2), and formulas which refer to results
of other formulas that refer to the cells, so it's not so simple to
trace all the dependencies

Any help is appreciated

Thanks
Dario
 
I'm not sure I fully understand, but if you are talking about Sheet1,
for example, and in Sheet2 you have formulae which refer to Sheet1
which are the ones you are trying to find, then it might be easier to
look for references to Sheet1!, rather than the cell references.

Hope this helps.

Pete
 
I'm not sure I fully understand, but if you are talking about Sheet1,
for example, and in Sheet2 you have formulae which refer to Sheet1
which are the ones you are trying to find, then it might be easier to
look for references to Sheet1!, rather than the cell references.

Hope this helps.

Pete
Click to expand...

Thanks Pete,

you're right, I can search using the sheet name, but I've a lot of
references (about 200) so I'm looking for a better method to obtain
the formulas that refer to a particular cell and trace all the
dependencies step by step.. But it seems not to exist a way to do it
if I've the formulas on sheets different from the referred cell, or
not?

Dario
 
Back
Top