Formula by combination of worksheet name and cell

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

Guest

Dear Helpers,

I have 60 worksheets of a group salesmen. I have successfully listed all
the worksheet names in a summary work sheet. If I need summarise their
sales figures, I need to go to each worksheet to link the specific cell to
the summary. For example,

Worksheet Name Sales figures
Peter (=Peter!$B$11)
Mary (=Mary!$B$11)

Is it possible to make formulaes by combining the name and cell to link to
the specific cells of each worksheet instead of going to each worksheet?

Thanks in advance

Fanny
 
How about something like this

=INDIRECT("'"&A1&"'!$B$11")

Where A1 contains the worksheet name. They'll need to match exactly for
this to work.
 
Back
Top