special sort

[brianscotte]

Is it possible to sort data in a specific way other than just strait ascending or descending order. For example I have a worksheet with 100's of entries. At one time I may need to select 50 or so of these to work with. I can create a macro to select copy and paste them into a new sheet. I then need to sort them in a specific way. To clarify in each row one of the cell values, in the column I need to sort, will have an A, B or C for the value. With a regular sort I can get all values in order ABC or CBA however sometimes I want to sort with B first not A or C. When I do sort this way (B first) A and C can be considered to have the same value. This means all Items with B show up first in the sort then A and C values will alternate based on second sort criteria.

[davidm]

If I understand your narration correctly, there is no reason why the normal Excel Worksheet Sorting tool cannot handle what you want to do.

--DAVID