How can I refer to a worksheet using text in a cell?
 

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?

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?

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?

How can I refer to a worksheet using text in a cell?
 

"Brevity is the soul of wit"

Yes, but long ago a very wise man said: (wrote) "Brevis esse laboro,
obscurus fio". (Horace, Ars Poetica 25/26 and, later, Quintilianus 9.3.65).

Jack Sons
The Netherlands

"Dave F" schreef in bericht
...
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?