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.
--
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

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