I think you have no response, because what you are asking (as I understand it) would be extremely difficult and therefore not something somebody is likely to want to try to tackle in a free public forum like this.
The problem is that Excel does not have a facilty for putting something at the bottom of pages (apart from footers of course). Additionally, the bottom of a page is generally not a 'fixed' thing. It depends on your printer & printer driver, row heights, paper size etc. So to do this you would have to, at the time of printing, try to determine where the bottom of each page was, add in a new row (making sure that did not cause an overflow to the following page), work out where the previous page finished, add totals for the current page, make sure that these totals were removed at some stage or at least that they were not adding in to your final grand total etc.
If you do happen to have hard-coded page breaks (that still leave room for a page total row without causing a spill over to the next page) then there may be a bit more of a chance. However, if that were the case you could probably just have subtotal formulas permanently at the bottom of each page. But if a user add/deletes rows changes font size, row height, margins etc you are likely to find that your print layout has gone astray.
