How can I refer to a worksheet using text in a cell?
You can also make cell A1 a named range, TOM, and make reference to that
named range. The disadvantage to this method is that if you have reason to
change the value in A1, the named range will not also change to the new
value. But I believe the formula Stefi gives would do that for you.
Dave
--
Brevity is the soul of wit.
"Stefi" wrote:
=INDIRECT(A1&"!A1")
gives you the value of cell A1 of sheet Tom.
Regards,
Stefi
€˛Preston€¯ ezt Ć*rta:
I'm trying to create a reference to another worksheet using the text in a cell.
For example I have a sheet called Tom, I put the text Tom in cell A1. I then
want to be able to refer to the worksheet Tom using the cell A1.
Is this possible?
|