Print Running Totals

The following will add all numbers in the E column and insert the total into the H column with a header in the G column at each page break. It also displays the total from the bottom of the last page. It also inserts a grand total at the last row.

Please Login or Register  to view this content.

Thanks dear..

but I m bit new for VBA..
Can you post sample excel sheet so that I can match it with my sheet.
or else I attached my sheet for ur reference

Vishnu

Thanks Dear....

I did It..

Vishnu

This sample is very helpful - I would like to use but instead of putting totals in another column insert two new rows and have the total print in Column E.

Can anyone help to edit this VB code please?

My main aim is preparing a large report - with variable length, and that subtotals each page and carries forward to next page. If this helps or makes a difference.

Many thanks,
Elliot.

Hi bruntone

Were you able to get your problem resolved? I know this is an old post but it's still relevant. I'm using Excel 2010. If you have a sample, that would be useful.

Would you be able to modify the code to include inserting a row to include the running total in the same column at the bottom of the page and the Previous Total in the same column at the top of the next page? Your assistance would be greatly appreciated.

Thanks

ltsolis