Formula with indirect addressing
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.
|