Can you write a formula in excel that can reference the source/or dependent cells of a specific cell?
words: I label my tabs 1,2,3,etc. If I link cell A1 in tab 1 to cell A1 in tab two I would like to be able to write a formula
in cell B1 of tab 1 that tells me that cell A1 is linked to tab 1. For a bonus I would like to be able to write a formula in
C1 that tells me any cells that are using cell A1. For example if tab 3, A1 was linked to tab 1, A1.
To put it in
to formula terms:
Cell A1 of tab "1" would look like this: ='2'!A2
Then I want to write a formula in Tab "1" Cell B1 that results in: "Tab 2" or even "Tab 2 Cell A2"
help with this?
I have a formula that will put the name of a tab in a specific cell. This is great for tables of
contents and creating titles to documents or footnotes, but it is a pain staking process to use this formula for the above
That formula looks like this:
I am currently using 2007.
whoever is smart enought to figure this out!