Because I'm populating this totals along with data dynamically.

Dave Peterson Wrote:
Why not just use Data|Subtotals?

ramse wrote:

Hi,

I'm cracking my head to do this task . I'm written some code its not
working fine. Pls help me out.

The macro have to sum the column data at last row whenever the type
chages.

type hr1 hr2
------ -- ---
S7 10 20
S7 30 30
S14 40 30
S14 20 50

S7 40 50

S14 60 80.

Your help is greatly appreciated.

Thanks,
Ram.

--
ramse

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

--

Dave Peterson


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