# Excel 2010 need to add subtotals to the end of each page

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.

###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
I'm sure that there is some fancy way to accomplish that with a macro - However - The problem becomes when you add a new item (row)  it will wipe out the total.  If you know about how large the sheet will grow to, Put the total at the top of the column.   So the total(s) cell will be =sum(L7:L10000)    =sum(M7:M10000)   and =sum(N7:N10000)
It will ignore the blanks when adding everything up

If you MUST have them at the bottom of the page - you would have to insert a row  somewhere in the range that is being totaled
0
Commented:
Try this put the sum(L6:L60000) on the around  the top of the page so
that you can add many number rows under row6 without affecting  the sum value
Duncan
0
Author Commented:
Thanks for your response Duncan, but I need each page to have a total for that page, and then a grand total on the last page.  Sorry, I'm sure I didn't make that clear.
0
Commented:
I just see one page in your workbook

Duncan
0
Commented:
Just reminder, did you know you can record what you edit or action you did or you want on Excel cell across different workbook and sheet into macro by Excel function of "Macro Recording" that will save  your expectation vba code into macro on VBA editor. Take a look at this Macro Recording tutorial at this site

Duncan
0
Excel VBA DeveloperCommented:
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
0

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Excel VBA DeveloperCommented:
Hi,

If you have any questions or issues with any of the solutions above, please let us know.

Otherwise, can you please properly close this question by clicking the "Accept this solution" link above the appropriate submission above that answers your question?.  This will help ensure that future searches are meaningful to other EE members.

If you still have issues or questions, please let us know.

Thanks,
-Glenn
0
Author Commented:
Works great!  Thanks Glenn
0
Excel VBA DeveloperCommented:
You're welcome.   Thank you for following up on this.

Regards,
-Glenn
0
###### It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.