how to carry forward a total from one page to another

[Martin ©¿©¬]

Hi
I have 4 pages on a spreadsheet, one for each quarter of the year
There are some totals I want to carry over to the next quarter & so on
Total on one page & brought forward totals on the next do not
necessarily have the same line/refrence number (if that makes sense)

How would I do this?
Using 2010
Thank you

 

[GS]

Hi

I have 4 pages on a spreadsheet, one for each quarter of the year
There are some totals I want to carry over to the next quarter & so on
Total on one page & brought forward totals on the next do not
necessarily have the same line/refrence number (if that makes sense)

How would I do this?
Using 2010
Thank you

Note that a 'page' is what prints, and so your ref to 4 pages on a
spreadsheet implies each qtr is on the same worksheet. I suspect you
really mean each qtr is on a separate worksheet in the same worbook!

I normally put an entire fiscal year on 1 worksheet and show
month/qtr/ytd for all because it makes calcs easier to manage (formula
wise), and allows me to expand/collapse to display details or summary
info by qtr or for the whole fiscal year when generating reports.

In your layout you can use defined names for your totals cols and ref
those in your formulas. If you make sure the defined names have local
scope on each sheet then you can use the same name over and over so
your formulas are consistant.

--
Garry

Free uenet access at http://www.eternal-september.org
Classic VB Users Regroup
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Martin ©¿©¬]

Hi
I have 4 pages on a spreadsheet, one for each quarter of the year
There are some totals I want to carry over to the next quarter & so on
Total on one page & brought forward totals on the next do not
necessarily have the same line/refrence number (if that makes sense)

How would I do this?
Using 2010
Thank you

Note that a 'page' is what prints, and so your ref to 4 pages on a
spreadsheet implies each qtr is on the same worksheet. I suspect you
really mean each qtr is on a separate worksheet in the same worbook!

I normally put an entire fiscal year on 1 worksheet and show
month/qtr/ytd for all because it makes calcs easier to manage (formula
wise), and allows me to expand/collapse to display details or summary
info by qtr or for the whole fiscal year when generating reports.

In your layout you can use defined names for your totals cols and ref
those in your formulas. If you make sure the defined names have local
scope on each sheet then you can use the same name over and over so
your formulas are consistant.

Yes thank you I really meant each qtr is on a separate worksheet in
the same workbook!
I should also have said I would like a formulae to carry a total from
one worksheet to the next worksheet & so on

 

[Martin ©¿©¬]

On Thu, 22 Aug 2013 12:59:44 +0100, Martin ©¿©¬

Ok thanks I got it sorted