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!

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!

"Wigi" wrote:

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


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"kay" wrote:

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!