I would avoid the VBA for this. I would use either Subtotaling (Data -
Subtotal) or a Pivot Table (Data - Pivot Table). My preference between the
two is a pivot table, but either solution will work for you. If you go with
the subtotaling then you need to sort your data prior to inserting the
subtotals...
--
HTH...

Jim Thomlinson


"ramse" wrote:


Hi,

I'm new to vb. pls help me out from this problem.

data in excel like this.
sttype hr1 hr2
------ -- ---
S7 10 20
S7 30 30
S14 40 30
S14 20 50

OUTPUT. in the last row looks like this.
S7 40 50
S14 60 80.

I've need output in the last row like above no of row are not fixed .

your help is greatly appreciated.

Thanks,
ramse.


--
ramse
------------------------------------------------------------------------
ramse's Profile: http://www.excelforum.com/member.php...o&userid=31544
View this thread: http://www.excelforum.com/showthread...hreadid=512404