Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 30
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to auto keep group of rows together and avoid a page break Stevo Excel Discussion (Misc queries) 2 October 17th 08 04:58 AM
How do I insert a Sub total at every page break? Sharon Excel Discussion (Misc queries) 1 February 20th 07 03:37 PM
Auto Page Break JAB Excel Worksheet Functions 8 May 26th 06 03:01 PM
AUTO INSERT PAGE BREAK FOR EACH COPIED HEADING wil4d Excel Discussion (Misc queries) 4 December 21st 05 04:02 AM
Is there a way to get an auto page break as data changes in Excel. george_visalia Excel Discussion (Misc queries) 2 December 16th 04 12:22 AM


All times are GMT +1. The time now is 02:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"