| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to Subtotal by Group
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotal Group Titles | Excel Programming | |||
| Subtotal won't group | Excel Discussion (Misc queries) | |||
| Subtotal Report: Creating new sheet(tab) for each group? | Excel Programming | |||
| Group / Outline / subtotal | Excel Discussion (Misc queries) | |||
| Excel subtotal group sort | Excel Worksheet Functions | |||
Threaded Mode
