Show all dependents
I have Excel 2002. I have looked at Jim Cone's code for producing another
sheet showing all of the dependents, cell references, formulas, etc.
However, I am looking at trying to produce the same report that would show
all of the dependents for a specific sheet. For instance I am on a
particular "data" sheet that other sheets refer to get data, I want to
produce something that shows for the "data" sheet all of the dependents, I
want to know which sheets are using the "data" sheet. Thanks in advance.
|