Macro should sort a range "E12:S500"by "Active" in Ascending order, no
header.

In the same macro, sort only the range of "Active" rows previously
sorted by "Quarter" (I have a list, 3Q03, 4Q03, 1Q04....) with no
header.

I can do the second piece, however, cannot combine it with the first.
Any ideas would appreciated. jh

Hi Joe,
Can you rearrange it in a helper column so it reads
2003Q3, 2003Q4, 2004Q1

--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Joe" wrote in message ...
Macro should sort a range "E12:S500"by "Active" in Ascending order, no
header.

In the same macro, sort only the range of "Active" rows previously
sorted by "Quarter" (I have a list, 3Q03, 4Q03, 1Q04....) with no
header.

I can do the second piece, however, cannot combine it with the first.
Any ideas would appreciated. jh