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 -