Would it be less work to remove the subtotals, do your sort (on product, then
customer), then reapply the subtotals?


On Wed, 4 Aug 2004 12:08:15 -0700, "JUAN" wrote:

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