Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort, Subtotal, Label Subtotal, Insert row
I have 4 columns. Need to do following:-
- sort by columns A, B, C in ascending order. - subtotal on change of column C - change subtotal text to "Subtotal for Sto XXX" where XXX is column C - insert a line after each subtotal for easy reading - insert grand total at end. I think this may sound easy for most of you. But I'm novice. Plse help. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal To Include Item Description On Subtotal Line | Excel Discussion (Misc queries) | |||
sort macro, subtotal and add lines after subtotal | Excel Discussion (Misc queries) | |||
subtotal label | Excel Discussion (Misc queries) | |||
How do I Subtotal, then Sort by Subtotal Amounts? | Excel Discussion (Misc queries) | |||
pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) |