Pull through totals to front page

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

Guest

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!
 
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
 
Back
Top