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