Excell Sheet Names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try this:

A1 = sheet name = Sheet2

To return the value of Sheet2 cell B10:

=INDIRECT("'"&A1&"'!B10")
 
Back
Top