Another sorting question - easy one!

[Terri]

Finally figured out how to sort my information but this is my next question.
Everything is sorted alphabetically by the first column (Name)...when I
enter a new name now, will it automatically sort? Or - do I have to do this
exercise of sorting on a constant basis.
Thanks!

 

[DM]

my experience say you have to sort manually every time unless you I import
it into Access and generate queries or reports.

you included details about ...alphabetically by the first column... is that
what you want? you can queue it to sort by which ever column(s) you want.

 

[Terri]

Yes I always want it by the first column

my experience say you have to sort manually every time unless you I import
it into Access and generate queries or reports.

you included details about ...alphabetically by the first column... is
that what you want? you can queue it to sort by which ever column(s) you
want.

 

[Don Guillett]

You could use a worksheet_change event to fire an automatic macro upon any
entry. Is this ONE cell in col A or any cell within a range of, say
a2:a200???

 

[Terri]

The ONE cell in Col A ranges from a2 to infinity...

 

[Don Guillett]

Private Sub Worksheet_Change(ByVal Target As Range)
lastrow=cells(rows.count,"a").end(xlup).row
Set myrng = Range("a2:f" & lastrow)
If Not Intersect(Target, myrng) Is Nothing Then
myrng.Sort Key1:=Range("a2"), Order1:=xlAscending, _
Header:=xlGuess, OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom
End If
End Sub