Macro to do the sum at the last when ever type chages

[ramse]

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.

 

[Dave Peterson]

Why not just use Data|Subtotals?

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]

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

 

[Jim Thomlinson]

So then lets go back to my post of yesterday... Why not use pivot tables?
Click refresh after re-populating the data and the totals will change
dynamically.