Print 16 entries per page with sub totals & totals

[Brian]

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]

If I had to do this, I'd start by trying to do it manually.

Combine all the data onto one sheet.
filter by your criteria
Copy those visible cells to a new worksheet
On that new worksheet, insert a new column (say before column A).

Put a "1" in the first 16 rows, then a "2" in the next 16, then "1" for 16
more....
Alternating until you're done.

Then apply Data|Subtotals
subtotal by column A and tell it to put a page break between groups.

Hide column A.

(subtotals at the bottom of the printed sheet isn't supported directly in
excel.)