Automatic sorting

[shaftdx]

Is there a way I can automatically sort a spreadsheet when I change a certain cell? I have a list of buses that are sorted by their bus number in column A. In column P there is a pull down menu based on their Status such as Active, Retired, Sold, Deadpool Ect. Is there a way that when I switch the status from active to Retired the sheet will automatically sort itself and move that row down to the other retired buses?

 

[Marc L]

Yes just using the event Worksheet_Change …

 

[shaftdx]

Yes just using the event Worksheet_Change …

Never used that before, I watched one video so far I will have to do more research but at least I know what to search for thank you!