I have a workbook with 4 sheets in. "Total", "2007", "2008" and "2009".
On the "Total" sheet cell

B1 contains "2007" and
B3 contains "='2007'!E3"

I would like to have the formula in cell B3 dynamic in such a way that I
can change the cell B1 to "2008" and by that have the cell B3 show the
value in cell "='2007'!E3".

I have tried different types of "Indirect" by with no luck.

Please tell me how to code this.

Hi Erik,

=INDIRECT(B1&"!E3")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Erik Mattsson" wrote in message ...
|I have a workbook with 4 sheets in. "Total", "2007", "2008" and "2009".
| On the "Total" sheet cell
|
| B1 contains "2007" and
| B3 contains "='2007'!E3"
|
| I would like to have the formula in cell B3 dynamic in such a way that I
| can change the cell B1 to "2008" and by that have the cell B3 show the
| value in cell "='2007'!E3".
|
| I have tried different types of "Indirect" by with no luck.
|
| Please tell me how to code this.