View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ivano Ivano is offline
external usenet poster
 
Posts: 28
Default find out which sheets refer to a cel

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,