View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson Myrna Larson is offline
external usenet poster
 
Posts: 863
Default Change Sort order Temporarily

I think you'll need to do this with a macro. Presumably the data must also be
sorted by column E also, or does the sort on column C get the column E data
into the correct order?


On Wed, 17 Nov 2004 08:31:52 -0600, hotherps
wrote:


I have a range A11:DZ298. Col B has a start time, Col C has an end time
and Col E has a alpha/numeric code that defines Start/End Combinations.


I am sorting By Col C, however if the value in E is "XJ8","C10",or"D10"
I need to sort that group of rows only by column B. Then switch back to
the regular sort on C again.

Possible?

Thanks