![]() |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 12:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com