Formula by combination of worksheet name and cell
 

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

Formula by combination of worksheet name and cell
 

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.
--
HTH,
Barb Reinhardt



"Fanny" wrote:

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

Formula by combination of worksheet name and cell
 

Dear Reinhardt,

Thanks very very much and it works well.

Fanny

"Barb Reinhardt" wrote:

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.
--
HTH,
Barb Reinhardt



"Fanny" wrote:

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