refer to two cells for location
Thanks! That works like magic!!!
"T. Valko" wrote:
If there are spaces or numbers in the sheet name then you have to use single
quotes around the sheet name:
A1 = sheet name = Week 2
B1 = a cell reference = A1
=INDIRECT("'"&A1&"'!"&B1)
Which evaluates to: ='Week 2'!A1
--
Biff
Microsoft Excel MVP
"E.Q." wrote in message
...
Could it be that you need the exclamation point? If cell A1 has sheet name
and A2 has cell location try
= Indirect(A1&"!"&A2)
|