Hi all,

I have data something like this:

Amount(A)Rec(B) Sub total(C)

1000 123
1500 123
2300 123
2400 111
1300 111
1150 111
1250 105
1000 102

....
how can i code to get a subtotal at the end of each rec
in my column c?

so my data will look like

Amount(A)Rec(B) Sub Total(C)

1000 123
1500 123
2300 123 4800
2400 111
1300 111
1150 111 4850
1250 105 1250
1000 102 1000

TIA

Soniya