ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excell Sheet Names (https://www.excelbanter.com/excel-discussion-misc-queries/155078-excell-sheet-names.html)

Patrick

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

T. Valko

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




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





T. Valko

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 10:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com