Soniya,

Why not create a pivot table, using column B as your row and column A as the
data item.

Cheers
Nigel

"Soniya" wrote in message
...
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




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---