macro to Subtotal by Group

K

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!
 
K

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top