Printing subtotals on each page
Thanks for the reply.
Does that mean I would have to work out how many rows and height of cells
will fit on a page with a row of subtotals. In other words would I have to
write my own reporting tool.
"Pete_UK" wrote:
It is not possible using the Data | Subtotals routine - you would need
your own VBA routine to do that.
Pete
On Mar 26, 12:56 am, slopsjon
wrote:
Thanks for the reply. I tried the Subtotals from the menu but that just seems
to Page Break Groups but doesn't put a subtotal on a page that over runs more
than one page. I only have one list of data with no grouping and need a
subtotal of columns on each page.
e.g.
Page 1
row
row
row
end of page running total
Page 2
row
row
row
end of page running total
Page 3
row
row
row
last page Total
Is that possible? Ta.
"Per Erik Midtrød" wrote:
On Mar 25, 10:52 pm, slopsjon
wrote:
I want to print out a spread sheet with subtotals on each page but the number
of rows and height of rows maybe different each time and I don't want to have
to manually adjust the print area and move the subtotal row around. Is there
anyway to do this automatically in Excel or do I need something with a
reporting tool.
If you go to subtotals on the menu instead of writing your own
subtotal function just check "Page break between groups"
Per Erik- Hide quoted text -
- Show quoted text -
|