What I want to do is create a custom footer. I tried using the excel tools but that is limited to dates, page numbers and so on. What I want to do is create a footer on each page at printing which has the totals for that page, next line is the total carried forward from previous page and the third line is the new total. So each page will
totals this page X
Total from previous Y
New total X+ Y
Naturally the next total will become the carry forward for the next page and so on. And this formula will be endless as I continue to add data and create more pages. If I have 200 lines of data, then page one may have 15 lines of data, the total feature on the bottom and then the next page will print 15-30 and so on.
Here is the trick, I'm thinking that each page is formatted to print
Does someone know how to do this.
totals this page X
Total from previous Y
New total X+ Y
Naturally the next total will become the carry forward for the next page and so on. And this formula will be endless as I continue to add data and create more pages. If I have 200 lines of data, then page one may have 15 lines of data, the total feature on the bottom and then the next page will print 15-30 and so on.
Here is the trick, I'm thinking that each page is formatted to print
Does someone know how to do this.