Auto sorting

[athertm]

Is there any simple way to automatically update a sorted list? Depending on values in a list I would like it to sort itself automatically. I have used some sort of bubble sort mechanism before but it's very long winded. Cheers.

[Juan Pablo González]

I think that you would have to do this using Macros.

Using something like this

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1:A5")) Is Nothing Then
    Range("A1:A5").Sort Range("A1"), xlAscending, Header:=xlYes
End If
End Sub

In Here, I'm sorting Range("A1:A5") each time one of the cells changes. I'm also assuming it has a title.