Sort in Subtotals

[JUAN]

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

 

[Myrna Larson]

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

 

[JUAN]

Hello myrna,
The thing is that the subtotals are already there. Which
this was created unsing a program that kicks the data in
excel. But I'll see what else I can do, was just hoping
that there was a way to sort between each group total.
Thanks,
Juan

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

 

[Stephen]

I guess you are using Excel's "DATA SUBTOTALS". Try using Excel's
"SUMIF" function to calculate the group subtotals outside the data
range. You can then sort your data ranges without affecting the group
subtotals.

StephenS