Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to carry forward a total from one page to another
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to carry forward a total from one page to another
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[s] 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to carry forward a total from one page to another
On Wed, 21 Aug 2013 13:26:05 -0400, GS wrote:
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[s] 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to carry forward a total from one page to another
On Thu, 22 Aug 2013 12:59:44 +0100, Martin ©¿©¬
wrote: Ok thanks I got it sorted |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I carry forward formula to next page of workbook? | Excel Discussion (Misc queries) | |||
linking cells to carry forward a hyperlink | Setting up and Configuration of Excel | |||
How do I insert a line in excel and carry the formula forward? | Excel Discussion (Misc queries) | |||
Calculate intermediate total on page change and carry it over. | Excel Discussion (Misc queries) | |||
Carry forward formula help needed | Excel Discussion (Misc queries) |