| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell Sheet Names
I have a need to refer to a sheet name from a main sheet , I need to refer
to the sheet name dynamically, ie, can i place the name of the sheet in a cell and then in another cell on the main sheet refer to that cell as the sheet name and then add the cell address?? Patrick |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excell Sheet Names
Try this:
A1 = sheet name = Sheet2 To return the value of Sheet2 cell B10: =INDIRECT("'"&A1&"'!B10") -- Biff Microsoft Excel MVP "Patrick" wrote in message ... I have a need to refer to a sheet name from a main sheet , I need to refer to the sheet name dynamically, ie, can i place the name of the sheet in a cell and then in another cell on the main sheet refer to that cell as the sheet name and then add the cell address?? Patrick |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excell Sheet Names
thanks,
"T. Valko" wrote: Try this: A1 = sheet name = Sheet2 To return the value of Sheet2 cell B10: =INDIRECT("'"&A1&"'!B10") -- Biff Microsoft Excel MVP "Patrick" wrote in message ... I have a need to refer to a sheet name from a main sheet , I need to refer to the sheet name dynamically, ie, can i place the name of the sheet in a cell and then in another cell on the main sheet refer to that cell as the sheet name and then add the cell address?? Patrick |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excell Sheet Names
You're welcome!
-- Biff Microsoft Excel MVP "Patrick" wrote in message ... thanks, "T. Valko" wrote: Try this: A1 = sheet name = Sheet2 To return the value of Sheet2 cell B10: =INDIRECT("'"&A1&"'!B10") -- Biff Microsoft Excel MVP "Patrick" wrote in message ... I have a need to refer to a sheet name from a main sheet , I need to refer to the sheet name dynamically, ie, can i place the name of the sheet in a cell and then in another cell on the main sheet refer to that cell as the sheet name and then add the cell address?? Patrick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excell how to make a cell rotate names when taken off top | Excel Worksheet Functions | |||
| How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
| Look up Webpage addresses from a List of company names in Excell? | Excel Worksheet Functions | |||
| How do I link 'tab names' to a cell in Excell spreadsheets | Excel Worksheet Functions | |||
| insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
Linear Mode
