View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Teak Teak is offline
external usenet poster
 
Posts: 1
Default 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.