This is the same code only I added a 2nd MsgBox showing valid entries possible if they enter invalid results after it sorts it. Otherwise, it is the same code. Obviously, it only works in the range of H4:H10 in your range of order_characters. You have to remove the data validation for the other cells in the range for it to work in those.