macro to Subtotal by Group

[kay]

Hi,
I have this columns in my sheets

Project Status col 1 col 2 col 3
1Project in delivery 10.0 20.0 30.0
2Sold Projects 20.0 1,000.0 50.0
2Sold Projects 2,000.0 5,000.0 200.0
3Prospects 30.0 50,000.0 60.0


Could anyone please help to write macro to sum up the value for each column
by project status.

I want in other sheet when i run a macro
Project status col1 col 2 col 3
1Project in delivery 10.0 20.0 30.0
2Sold Projects 2,020.0 6,000.0 250.0
3Prospects 30.0 50,000.0 60.0


Thanks!

 

[Wigi]

You don't need to program anything. Use a pivot table.

 

[kay]

Thanks!
I know we can do this with pivot table
but I need this subtotal in diff sheet to do some more calculation.
so i dont have much exp. in macro. that's why need help how can i do this
using macro.

Thanks!