Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
page control & sub-totals
I have a list of say 100 entries that contain the
following: Account# Name Amount I need to be able to print a subset of those entries with 16 entries per page with a sub-total on each page and a grand total at the end. Using autofilters I can select the subset of the data I want to print. Since the entries can change I'd rather not have to manually set up new fields to use the sub- total function since it would be prone to user errors whenever the information changes. I've currently got the data segregated on multiple worksheets with manual page breaks and manual sub-totals via a normal =sum() formula. I'm trying to use one master list in a single worksheet and let the program handle the breaks and formulas. Is there any good way to convince Excel to print the report with a subtotal on each page and a grand total at the end? thanks, Brian |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
page control & sub-totals
See one workaround at your other post.
Brian wrote: I have a list of say 100 entries that contain the following: Account# Name Amount I need to be able to print a subset of those entries with 16 entries per page with a sub-total on each page and a grand total at the end. Using autofilters I can select the subset of the data I want to print. Since the entries can change I'd rather not have to manually set up new fields to use the sub- total function since it would be prone to user errors whenever the information changes. I've currently got the data segregated on multiple worksheets with manual page breaks and manual sub-totals via a normal =sum() formula. I'm trying to use one master list in a single worksheet and let the program handle the breaks and formulas. Is there any good way to convince Excel to print the report with a subtotal on each page and a grand total at the end? thanks, Brian -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
stop page totals creeping up page when scrolling | Excel Discussion (Misc queries) | |||
PAGE TOTALS? | Excel Discussion (Misc queries) | |||
HOW DO I SETUP A PAGE IN EXCEL TO GIVE TOTALS TO ANOTHER PAGE | Excel Worksheet Functions | |||
print footer on every page (Totals on every page) | Excel Discussion (Misc queries) | |||
how to get column totals on each page? | Excel Worksheet Functions |