montrof
asked on
Custom sort
I have two columns that I want to custom sort, The first column guides how the second column can be sorted the First is sorted alphabetically. The second column is also but I want the first value to always be the value "Orange" if it is available. Example
Object Color
Door red
Door orange
Door Blue
Door Yellow
Chair orange
Chair blue
Chair red
Chair yellow
Chair pink
Chest red
Chest blue
Chest green
The way I want the sort to look each time
Object Color
Door orange
Door Blue
Door red
Door yellow
Chair orange
Chair blue
Chair pink
Chair red
Chair yellow
Chest blue
Chest green
Chest red
Thanks,
Montrof
Object Color
Door red
Door orange
Door Blue
Door Yellow
Chair orange
Chair blue
Chair red
Chair yellow
Chair pink
Chest red
Chest blue
Chest green
The way I want the sort to look each time
Object Color
Door orange
Door Blue
Door red
Door yellow
Chair orange
Chair blue
Chair pink
Chair red
Chair yellow
Chest blue
Chest green
Chest red
Thanks,
Montrof
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I took what you said and just made it into a macro and works perfect.
Thanks,
Montrof
Thanks,
Montrof
ASKER
Thanks for the reply but I need this to be done in vba because this is a piece of what I am trying to accomplish. The data is loaded each day so that is why I want to automate it.
Thanks,
Montrof