How to automatically sort a column?

[jaedmar]

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.

 

[VoG]

Which column?

 

[VoG]

OK well this assumes scores in column B and names in column A. Change the 2 to the column number with the scores (e.g. 5 for column E). Right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then
    Application.EnableEvents = False
    Range(Cells(2, 1), Cells(Target.Row, Target.Column)).Sort Key1:=Cells(2, Target.Column), Order1:=xlAscending, _
        Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
    Application.EnableEvents = True
End If
End Sub

 

[jaedmar]

Need to sort Column C from lowest number to highest number.

 

[VoG]

Change 2 to 3.

 

[scolty1985]

i was lookin at this earlier today and trimed the example i found down to the following.

Columns("C").Sort Key1:=Range("C2"), Order1:=xlAscending, _
        Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

VOG code is probably better but for my purposes this worked for me.

 

[jaedmar]

VoG,
I tried that macro, but couldn't get it to work. Maybe I didn't do it rigtht.
Anyway, I have since changed the sheet a bit. Here is what I have now

Column A_____Column B_____Column C_____Column D_____Column E
--RANK---------NAME----------ID#----------SCORE--------AWARD--

This sheet is automatically populated after names and scores are entered in another sheet. The rank is assigned, but is not listed in numerical order.

What I want to do is to have the rank column automatically adjust to list ranks in order from 1 to x (cells A2 to A a77). I want the entire rows to adjust with the rank, so the correct name, ID#.... stay with the assigned rank.

So, if I adjusted a person's score on the other worksheet affecting a person's ranking, this sheet would automatically adjust all columns based on person's rank in Column A.

Does that make sense?