Ramse,
I could answer your question but I choose not to. You really need to read
something about VBA rather than hoping that someone will write code for you.
The best use of a newsgroup is to pose specific questions about subjects you
know something about after you've made a best effort to solve the problem
for yourself.

D

"ramse" wrote in
message ...

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