| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing worksheet names from a list??
Hi
On one of my worksheets, I have a vertical list of all the worksheet names that are in the xls file. Next to each worksheet name in the list, I am trying to create a formula that references the worksheet name and returns a particular cell value within that worksheet. I have been tinkering with the INDIRECT function but can't seem to string it all together. Any clues on how to do this? Cheers Bull |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Referencing worksheet names from a list??
Try this:
A1 = Sheet Name =INDIRECT("'"&A1&"'!B27") Which evaluates to: ='Sheet Name'!B27 -- Biff Microsoft Excel MVP "Ace70" wrote in message ... Hi On one of my worksheets, I have a vertical list of all the worksheet names that are in the xls file. Next to each worksheet name in the list, I am trying to create a formula that references the worksheet name and returns a particular cell value within that worksheet. I have been tinkering with the INDIRECT function but can't seem to string it all together. Any clues on how to do this? Cheers Bull |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Referencing worksheet names from a list??
Awesome! Perfect. Thanks
|
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Referencing worksheet names from a list??
You're welcome!
-- Biff Microsoft Excel MVP "Ace70" wrote in message ... Awesome! Perfect. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to list tab/worksheet names in a summary worksheet | Excel Discussion (Misc queries) | |||
| List of worksheet names | Excel Discussion (Misc queries) | |||
| want a list of selectable names on my worksheet | Excel Worksheet Functions | |||
| how can you list all of the worksheet names in a file | Excel Discussion (Misc queries) | |||
| Referencing worksheet names | Excel Worksheet Functions | |||
Linear Mode
