Using cells to refer to worksheets
 

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

Using cells to refer to worksheets
 

Hi Rup,

Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Rup1776" wrote in message ...
| 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