How do I make a column of cells sort in order of lowest to highest as soon as I enter a test score in the next empty cell? Also I want to make sure that the adjacent column with people's names is sorted to coincide with the correct test score.
I want it to sort automatically, without me having to highlight and sort each time.
I want it to sort automatically, without me having to highlight and sort each time.