Contents of a cell refer to sheet name
=Indirect("'" & A1 & "'!C5")
the single quote is to the left of the exclamation point.
--
Regards,
Tom Ogilvy
"Audio_freak" wrote in message
. 2.2...
Hello there
I would like to do something like this:
in sheet1 the value of cell A1="sheet2"
in sheet1 the formula in cell B1 should be something like:
='A1!'C5
so that it will look in sheet2 because that's the value in A1.
Doesn't work, does it?
Thanks
Peter
|