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

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

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?


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

.

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!