- Aug 20, 2018
- Office Version
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?