| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I format alphabetically in a column?
I have a list of a hundred names last name first, etc. I have entered in a
spread sheet and I would like to format the first column to alphabatize when a new entry is made, Possible?? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I format alphabetically in a column?
Try this worksheet event macro. It will automatically alphabetize column A
whenever an entry is entered or changed: Private Sub Worksheet_Change(ByVal Target As Range) Set r = Range("A:A") If Intersect(r, Target) Is Nothing Then Exit Sub Application.EnableEvents = False Columns("A:A").Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess Application.EnableEvents = True End Sub -- Gary''s Student - gsnu200792 "Brian k" wrote: I have a list of a hundred names last name first, etc. I have entered in a spread sheet and I would like to format the first column to alphabatize when a new entry is made, Possible?? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I arrange columns alphabetically by column label? | Excel Worksheet Functions | |||
| How do you arrange text alphabetically in a column? | New Users to Excel | |||
| How do I sort a column alphabetically not consider "the" or "a"? | Excel Discussion (Misc queries) | |||
| How do I combine tabulated data into a single column and list alphabetically? | Excel Discussion (Misc queries) | |||
| How do I arrange entries in a column alphabetically | Excel Discussion (Misc queries) | |||
Linear Mode
