| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| refer to last cell in worksheet? | Excel Worksheet Functions | |||
| How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
| Copy text from text box to cell in another worksheet | Excel Worksheet Functions | |||
| Using 'If' refer to specific words in a cell containing text | Excel Worksheet Functions | |||
| HOW CAN I AUTO FILL A CELL WITH TEXT FROM ANOTHER WORKSHEET TEXT . | Excel Worksheet Functions | |||
Linear Mode
