ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   page break with auto sub total (https://www.excelbanter.com/excel-worksheet-functions/241782-page-break-auto-sub-total.html)

Sudipta Sen[_2_]

page break with auto sub total
 
Suppose a list of 4 to 5 pages.

I want to get automatic subtotal in the end row of every pages and grand
total in last row of last page. that means, the last row of 1st pages will be
carried the subtotal which will be brought forward automatically in the 1st
row in the 2nd pages., even if i insert a row in the 1st pages the subtotal
& grand total will be automatically changed and after taking printout carry
forward and brought forward will be found in every pages.


All times are GMT +1. The time now is 04:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com