Automatically sorting names alphabetically.

B

Brenden

Hello,

I may be asking for to much on this one!

I have a list of names in a column, they are in column B2 on up to B90. I know how to select the entire column B and then hit the sort "A-Z" button to sort alphabetically. What I would like to know is if there is a way to automatically sort a name alphabetically after typing it into the next availabel cell, B91. For example, if cell B90 is filled with a name and I enter a new name into B91 and hit enter I want this new name to automatically alphabetize itself throughout the entire B2 through B91 column. This list will be continually added to so I need this list to alphabetize itself because it is getting to large! Is this impossible or is there a formula for is type of wish?

Thanks,
Brenden
 
B

bj

one way to do it (in EXCEL 2002 at least ) is to right
click on the tab and select "View Code" select "Worksheet
for the box at the top left and enter the following macro
(Assuming data is in the Column A)

"Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Columns("A:A").Select
Selection.Sort Key1:=Range("A1"), Order1:=xlAscending,
Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False,
Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Application.EnableEvents = True
End Sub"


-----Original Message-----
Hello,

I may be asking for to much on this one!

I have a list of names in a column, they are in column B2
Click to expand...
on up to B90. I know how to select the entire column B and
then hit the sort "A-Z" button to sort alphabetically.
What I would like to know is if there is a way to
automatically sort a name alphabetically after typing it
into the next availabel cell, B91. For example, if cell
B90 is filled with a name and I enter a new name into B91
and hit enter I want this new name to automatically
alphabetize itself throughout the entire B2 through B91
column. This list will be continually added to so I need
this list to alphabetize itself because it is getting to
large! Is this impossible or is there a formula for is
type of wish?
 
Top