PC Review


Reply
Thread Tools Rate Thread

automatic subtotal pagewise

 
 
Sudipta Sen
Guest
Posts: n/a
 
      28th Oct 2009
I creat a list of data with salary amount.
Now I need subtotal pagewise automatically and the grand total at last page.

In other sense, need carriad forward brought forward in every page as we get
tally or any other accounts package.
 
Reply With Quote
 
 
 
 
Sean Timmons
Guest
Posts: n/a
 
      28th Oct 2009
Unfortunately, Excel does not recognize pages when performing subtotals. What
you can do is determine how many rows you will have per page and enter your
subtotals where you desire.

"Sudipta Sen" wrote:

> I creat a list of data with salary amount.
> Now I need subtotal pagewise automatically and the grand total at last page.
>
> In other sense, need carriad forward brought forward in every page as we get
> tally or any other accounts package.

 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      28th Oct 2009
Pagewise means when you print that worksheet?

If yes, then excel doesn't have anything like that built in.

You could insert your own pagebreaks (manually) and add your subtotals
(manually) if you really needed this.

Sudipta Sen wrote:
>
> I creat a list of data with salary amount.
> Now I need subtotal pagewise automatically and the grand total at last page.
>
> In other sense, need carriad forward brought forward in every page as we get
> tally or any other accounts package.


--

Dave Peterson
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pagewise total Devaraj Microsoft Excel Misc 4 5th Dec 2009 09:45 AM
subtotal - missing subtotal for last record Service Pack 2 kenlyn@americollect.com Microsoft Excel Discussion 3 8th Mar 2006 10:22 PM
Subtotal of Subtotal displays Grand Total in wrong row Thomas Born Microsoft Excel Worksheet Functions 5 6th Jan 2005 02:46 PM
Last inner row in nested subtotal falls below outer subtotal. =?Utf-8?B?LVdlcw==?= Microsoft Excel Crashes 0 11th Nov 2004 12:22 AM
Sort, Subtotal, Label Subtotal, Insert row Teak Microsoft Excel Programming 2 8th Apr 2004 04:14 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:01 PM.