Automatically sort data using a custom list when entering new data

[cavalier13]

Hello,

I would like to sort my data by the data in column A whenever I add new data to that column. I can easily sort the data alphabetically automatically, however I would like to sort this data by a custom order. The 4 different inputs allowed for this column are 1. keep/sold, 2. must win, 3. top tier, and 4. new business, and I would like the data to automatically sort in this order (top to bottom) whenever I add a new input into this column A. Any help would be much appreciated.