Hi Michael,

Perhaps an event macro like this will do.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column < 1 Then Exit Sub
Range("A:A").Sort Key1:=Range("A1"), Order1:=xlAscending
End Sub

HTH
Regards,
Howard

"tomcat017" wrote
in message ...

Hello All,

I am entering some database information into an excel
spreadsheet--namely, clients' names, addresses, phone #s, etc. I know
how to make excel alphabetize all the data according to the name
column. However, there are many duplicates that I come accross, and
so, I find myself having to alphabetize after every entry. Is there
any way to make excel alphabetize every time i move to the next row?
Thanks,

-Michael


--
tomcat017
------------------------------------------------------------------------
tomcat017's Profile:
http://www.excelforum.com/member.php...o&userid=30911
View this thread: http://www.excelforum.com/showthread...hreadid=505886