Change Sort order Temporarily
 

I have a range A11:DZ298. Col B has a start time, Col C has an end tim
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 t
the regular sort on C again.

Possible?

Thanks :confused

--
hotherp
-----------------------------------------------------------------------
hotherps's Profile: http://www.excelforum.com/member.php...nfo&userid=505
View this thread: http://www.excelforum.com/showthread.php?threadid=31435

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 :confused: