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
|