ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Totaling Each Page (https://www.excelbanter.com/excel-discussion-misc-queries/31124-totaling-each-page.html)

Scott

Totaling Each Page
 
I have a monthly report that I need to submit. The report consists of
different amount of rows each month, and I need to display each page total at
the bottom. The original source data comes from a csv file, which usaully
spans 500 - 900 rows. Is there an easier way to display page totals on each
page, then using the autosum function each column using the last row on each
page? Currently I merge the data source and then print preview the worksheet,
which displays the page breaks. I then insert a new row at the bottom of each
page to create the page totals. There has to be an easier way!! Thanks!




All times are GMT +1. The time now is 07:17 PM.

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