View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default automatic subtotal pagewise

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.