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