dynamic sheet name in a formula
Try
=INDIRECT("'"&referencesheet&"'!D111")/INDIRECT("'"&referencesheet&"'!D101")
first indirect should evaluate to 'maryssheet'!D111 and the second to
'maryssheet'!D101
"dogsnapper" wrote:
I would like to have a formula like this:
='maryssheet'!D111/'maryssheet'!D101
but the name of the sheet will change each name, let's say, to "harryssheet"
next month or who knows what the next month's sheet's name will be.
BUT the cell references and the overall formula will stay the same.
therefore, i am thinking that if possible i would like to have a cell on a
sheet called "referencesheet" where i can put the name of the sheet to
substitute in the formula each month that would just change the sheetname in
the formula... or something to that effect.
Help?
|