Using cells to refer to worksheets

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

Guest

Hello,

I am trying to SUM the total number of a specific colunm for a number of
different worksheets, in the same worksheet.

I.e. Sheets are named 'Ward 3', 'Ward 5' etc, and in my 'Total Contacts'
sheet I want to SUM up the column H3:H36 for each of those worksheets. So I
have been able to generate the correct formula for each worksheet
A B
Contacts
Ward 3 =SUM('Ward 3'!H3:H36)

Is there a way to use the text in column A to generate the formula in column
B. rather than copying and changing the formula?

Im not sure how clear the question is so please ask!!!

Thanks

Rup
 
Hi Rup,

Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello,
|
| I am trying to SUM the total number of a specific colunm for a number of
| different worksheets, in the same worksheet.
|
| I.e. Sheets are named 'Ward 3', 'Ward 5' etc, and in my 'Total Contacts'
| sheet I want to SUM up the column H3:H36 for each of those worksheets. So I
| have been able to generate the correct formula for each worksheet
| A B
| Contacts
| Ward 3 =SUM('Ward 3'!H3:H36)
|
| Is there a way to use the text in column A to generate the formula in column
| B. rather than copying and changing the formula?
|
| Im not sure how clear the question is so please ask!!!
|
| Thanks
|
| Rup
 
Back
Top