Automatic data sorting based on cell value

miljasini 

What you're describing makes sense, in some ways, but also raises questions. Could I ask:

• how many rows are you dealing with here?
• how do you find the item(s) that you want to change?

If you've got a LOT (hundreds or more) of rows in total, it might make more sense to have one sheet you use as an Input sheet, and another as the Output.

• The former--the Input sheet--would be all in alphabetical order by Project or Product (or Whatever) Name, regardless of the Y,N,W,E code associated. That's where you'd change or update various items, including the YNWE codes.
• The latter--the Output sheet--would draw from the former where, by means of the SORT function, items would automatically be sorted in whatever order you wanted, dynamically and in real time. All of your color coding could be included as well.

This kind of design follows the practice of separating input from output. You've made it trickier by using one sheet to accomplish both ends of the process; workable so long as the number of rows is limited, but more and more awkward as more items need to be tracked.

Here are two resources where you can learn about the new (you will need the 2019 or newer version of Excel). 

• A great Microsoft video: https://www.youtube.com/watch?v=9I9DtFOVPIg
• A good instructional website: https://exceljet.net/functions/sort-function