Hello,

I would like to use the value of a cell to be the name of a sheet in a
formula. So for instance:

A1 contains the word "Sheet1"
A2 has the formula "='Sheet1'!C3"

Rather than put the sheet name in A2, is it possible to use the value
in A1 in the formula in A2?

hope that makes sense.


--
bluegnu
------------------------------------------------------------------------
bluegnu's Profile: http://www.excelforum.com/member.php...o&userid=36108
View this thread: http://www.excelforum.com/showthread...hreadid=558830