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
.
Can anyone help?
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
.Can anyone help?
