| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use of the Contents of a cell as a worksheet name in a function
How does one use the contents of a cell to contain the name of a worksheet
and then use those contents in a formuala... e.g. A1 = separate worksheet name A2 = contents of (separate worksheet name!A2) A3 = contents of (separate worksheet name!A3) etc. etc... ( like to use fill down from here) Played with indirect for awhile but I am missing something... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Use of the Contents of a cell as a worksheet name in a function
Try this in A2:
=INDIRECT("'"&A$1&"'!A"&ROWS($1:2)) Copy down as needed -- Biff Microsoft Excel MVP "tooMuchFun" wrote in message ... How does one use the contents of a cell to contain the name of a worksheet and then use those contents in a formuala... e.g. A1 = separate worksheet name A2 = contents of (separate worksheet name!A2) A3 = contents of (separate worksheet name!A3) etc. etc... ( like to use fill down from here) Played with indirect for awhile but I am missing something... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Use of the Contents of a cell as a worksheet name in a functio
Thank you... works like a champ
"T. Valko" wrote: Try this in A2: =INDIRECT("'"&A$1&"'!A"&ROWS($1:2)) Copy down as needed -- Biff Microsoft Excel MVP "tooMuchFun" wrote in message ... How does one use the contents of a cell to contain the name of a worksheet and then use those contents in a formuala... e.g. A1 = separate worksheet name A2 = contents of (separate worksheet name!A2) A3 = contents of (separate worksheet name!A3) etc. etc... ( like to use fill down from here) Played with indirect for awhile but I am missing something... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Use of the Contents of a cell as a worksheet name in a functio
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "tooMuchFun" wrote in message ... Thank you... works like a champ "T. Valko" wrote: Try this in A2: =INDIRECT("'"&A$1&"'!A"&ROWS($1:2)) Copy down as needed -- Biff Microsoft Excel MVP "tooMuchFun" wrote in message ... How does one use the contents of a cell to contain the name of a worksheet and then use those contents in a formuala... e.g. A1 = separate worksheet name A2 = contents of (separate worksheet name!A2) A3 = contents of (separate worksheet name!A3) etc. etc... ( like to use fill down from here) Played with indirect for awhile but I am missing something... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| Reflect cell contents into another worksheet | Excel Discussion (Misc queries) | |||
| Reflect cell contents into another worksheet | Excel Discussion (Misc queries) | |||
| Reflect cell contents into another worksheet | Excel Discussion (Misc queries) | |||
| What worksheet function will formatlessly copy cell contents? | Excel Worksheet Functions | |||
Linear Mode
