View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JUAN JUAN is offline
external usenet poster
 
Posts: 39
Default Sort in Subtotals

Hello,
is it possible to sort in excel when you have group
subtotals? I can select by range and sort but dont' want
to do it manually. Plus since the rows might change a
macro that specified range will not work.
Example,
Cust name should be
AZX ABC
BBC AZX
ABC BBC
Total PROD 1
TEST2 CATR
CATR TEST2
Total Prod 2
Manually I could do it, but if I have ten groups too much
to do. So please advise any help, would appreciate.
thanks,
Juan