View Single Post
  #1   Report Post  
Scott
 
Posts: n/a
Default 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!