How can I refer to a worksheet using text in a cell?
=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?
|