Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Printing subtotals on each page
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Printing subtotals on each page
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Printing subtotals on each page
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Printing subtotals on each page
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 - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Printing subtotals on each page
Yes, that is correct if you wanted a general purpose routine, and you
would also need to take account of any header/footer space etc. However, you may decide that you want 50 rows per page, say, so that would make it easier to code. Hope this helps. Pete On Mar 26, 10:20*am, slopsjon wrote: 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 -- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page subtotals | Excel Discussion (Misc queries) | |||
Excel Printing --Borders are not printing on the same page as data | Excel Discussion (Misc queries) | |||
subtotals to a different page. | New Users to Excel | |||
Printing what I can see on the screen - subtotals | Excel Discussion (Misc queries) | |||
Printing what I can see on the screen - subtotals | Excel Discussion (Misc queries) |