Variable sheet name in formula
Hi
use INDIRECT for this.
--
Regards
Frank Kabel
Frankfurt, Germany
"Eric" schrieb im Newsbeitrag
...
Hello,
I dont know if this is possible, but I am trying to build a formula
which
contains the name of a sheet that will change every day.
In fact, I would like a cell to contain the name of the sheet and
then
reference the content of that cell in my formula.
Ex: sheet2.A3 would contain the text "Sheet2"
my formula would look like = sheet2.A3!B4*C45........., where
sheet2.A3!B4
would be cell B4 of sheet2.
Thank you.
Eric.
|