Atomatic subtotal in every pages.

[Sudipta Sen]

Supoose a list of 100 datas. where want to get total in 1st pages & brought
forward to the second pages
eg.
pAGE 1
A B C D
1 JHONE 20
2 MERY 10
3 SMITH 30
4 JERRY 15
----------------------------
5 C/F 75

pAGE 2

6 B/F 75
7 GOOMS 10
8 HERRY 20
9 PETER 5
10 HELEN 15
11 JASTINA 20
--------------------------
12 TOTAL 145
13

Automatically this Carry Forward & Broght Forward will be coming in pagewise
means every pages. So If i will take a print out of 2nd Page I will get the
total of 1st page after heading row and total of 2nd page at the last row of
2nd page. Similarly I I will take print out of 3rd Pages, get total of 2nd
pages after heading row and total of 3rd pages in last row of 3rd pages.

How can I do it?

 

[Eduardo]

Hi,
You can have your totals in Row 1 or in the last row with the formula as
follow in page 1, lets say cell A102

=subtotal(9,A1:A100)

Then in page 2 first row enter

=Sheet1!A102

and again at the end enter formula given above,

if this helps please click yes thanks