Pull through totals to front page
 

I would like to pull through total amounts from a number of worksheets to sit
at the main front navigation page. Within the worksheets, the total figure
sits in column C:3. Each worksheet has a different name - for example:
Castlehead. Hope you can help!

Pull through totals to front page
 

Hello
Place the following formula into your main sheet
=SUM(Zozo:Zaza!C3)
Where Zozo is the name of your first sheet and Zaza is the name of your last
sheet.

See also Data, Consolidate.

HTH
Cordially
Pascal


"slavenp" a écrit dans le message de
news: ...
I would like to pull through total amounts from a number of worksheets to
sit
at the main front navigation page. Within the worksheets, the total
figure
sits in column C:3. Each worksheet has a different name - for example:
Castlehead. Hope you can help!