running totals

[pam]

I have a worksheet that will have many multiple pages.
On each page I need a total of Column F on that page. In
another cell I need a running total on all pages. I know
how to do it manually on each page. I need to know if
there is a way to have it automatically do it on each page
with out me having to do something on the page.

Please help!

 

[Bernard Liengme]

Hi Pam,
You can 'group' the worksheets ('pages'). Click on the Sheet1 tab, hold down
Shift key and click on the tab of the last sheet. Select the cell where
formula goes and type formula. Click on any single sheet tab to ungroup. The
formula appears on all sheets.
Bernard