G
Guest
Hi,
I have a few worksheets that I called lookups1, lookups2, lookups3... which
contains values that many other sheets refer to as part of an index,
vlookup... formula. How do I find out which sheets refer to this lookups1
sheet. I tried the trace dependants and although it puts a symbole refering
to somethin it doesn't tell me the sheet names that refer to it? What I want
to know is which sheets use the lookups to pull values.
Thanks,
I have a few worksheets that I called lookups1, lookups2, lookups3... which
contains values that many other sheets refer to as part of an index,
vlookup... formula. How do I find out which sheets refer to this lookups1
sheet. I tried the trace dependants and although it puts a symbole refering
to somethin it doesn't tell me the sheet names that refer to it? What I want
to know is which sheets use the lookups to pull values.
Thanks,