How to get formulas starting from the referenced cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dario - 28 Aug 2007 14:06 GMT

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

Reply to this Message

Pete_UK - 28 Aug 2007 17:38 GMT

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

> Hi all,
>
[quoted text clipped - 13 lines]
> Thanks
> Dario

Reply to this Message

Dario - 29 Aug 2007 09:40 GMT

> 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
[quoted text clipped - 22 lines]
> > Thanks
> > Dario

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

Reply to this Message

Rate this thread: