S
SeanTC61
I have set a spred sheet that has hyperlinks to other sheets. In doing this I
have also set the cell name to change to the name of the sheet. I need to
make a formula that refers to the newly created worksheet at specific cells.
Example I have a worksheet named Test1
In my master worksheet (MasterA3) I have a Hyper link cell that will take me
directly to this page that gets its name from the Test1 worksheet.
In cel MasterA4 I need to refer to Test1C3.
I would like to get the name of the page (`test1'!C2) by refering to MasterA3.
I assume I will have to use some type of nested formula, How can I do this?
Thank you.
have also set the cell name to change to the name of the sheet. I need to
make a formula that refers to the newly created worksheet at specific cells.
Example I have a worksheet named Test1
In my master worksheet (MasterA3) I have a Hyper link cell that will take me
directly to this page that gets its name from the Test1 worksheet.
In cel MasterA4 I need to refer to Test1C3.
I would like to get the name of the page (`test1'!C2) by refering to MasterA3.
I assume I will have to use some type of nested formula, How can I do this?
Thank you.