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.
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.