how to carry forward a total from one page to another

  • Thread starter Thread starter Martin ©¿©¬
  • Start date Start date
M

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
 
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
Click to expand...

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
 
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
Click to expand...

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.
Click to expand...


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