lvmllc
asked on
Excel sheet name from a cell value
I have a workbook that includes several worksheets that are each named with a unique identifier.
One of the sheets is my summary page that references values form each of the sheets. Because it is a pain to write out the name of the sheet each time I copy a formula I would like to grap the name of the worksheet from a value.
for example something like this is in cell B3
='B2'!B3
so if B2 on my current sheet is 'cjs123' then the formula should go to the sheet called cjs123 and retrieve the value in cell B3.
How can I create this functionality?
One of the sheets is my summary page that references values form each of the sheets. Because it is a pain to write out the name of the sheet each time I copy a formula I would like to grap the name of the worksheet from a value.
for example something like this is in cell B3
='B2'!B3
so if B2 on my current sheet is 'cjs123' then the formula should go to the sheet called cjs123 and retrieve the value in cell B3.
How can I create this functionality?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thomas, I think your first response second example was missing a " behind b3. otherwise both yours and ssaqibh got me on the right track.
=indirect("'"&b2&"'!" & address(row(),column()))
Thomas