Use the value of a cell as the sheet name in a cell formula

S

Simon H

Hi all

I have the following problem thats melting my head...

I have a worksheet as a summary sheet with a column containing values
equal to the names of other worksheets in the workbook.

Say I have a column withe values: 1, 2, 3, 4, etc

and worksheets named: 1, 2, 3, 4, etc

And I have a cell in the summary sheet which I would like to use as
follows:

(Pseudo)
= 'valueOfCell_A2'!$C$41
^^^^^^^^^^^^^^
I need to use the value of a cell to create a reference to the
worksheet within the formula.

I hope this makes sense.

Any help would be much appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top