Subtotal Using SUM in Footer for each Printed Page

adh747

New Member
Joined
Oct 5, 2014
Messages
1
Hi,

Looking for some help to create a dynamic footer for each printed page in a worksheet which sums the subtotals for each page. Have tried searching for a solution and have come across a few VBA codes but can't get any to work the way I need.

I have a worksheet with six columns. The sixth column contains values which are subtotalled on various rows as you go down the list. I've labelled each row with a subtotal "Subtotal" and can sum all the subtotals within the worksheet at the bottom. However I'm attempting to create a page total for the subtotals on that page when printing in the right footer. I understand this needs VBA code which will change the footer dynamically for each printed page but have no idea where to start:confused:.

Can anyone help?
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Watch MrExcel Video

Forum statistics

Threads
1,108,630
Messages
5,523,991
Members
409,554
Latest member
denistrevisan

This Week's Hot Topics

Top