新聞財經娛樂♬資訊 News Economy

I am using Excel 2010. I have a worksheet that will grow over time.  It currently has 3 pages.  I need a subtotal to appear at bottom of each page, preferably not in the footer, but at the bottom of the text on each page.  Columns that need totals are L, M & O.  It could be that we will adjust row height and the number of rows per page may change at some point in time.
I have attached the worksheet.

Thanks for your help.

You're welcome.   Thank you for following up on this.

Regards,
-Glenn

I looked at modifying the existing macros in your workbook, but none of them appeared to run properly, so I just created two new ones.  I added buttons to the sheet that will let you add or remove the subtotal lines at your discretion.

These macros will insert a subtotal line to the bottom of each sheet (every 26 rows of data) and add a final grand total line at the end.

A possible issue would occur if your final page had exactly 26 rows, in which case the grand total line would fall on its own page.  Otherwise, it should run with as many rows as you have in your worksheet.  With each iteration, you'd want to remove existing subtotals first, then add them back again.

Regards,
-Glenn