Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
list that alphabetizes itself w/each new name
How do I make a customer list that alphabetizes itself with each new entry?
I need to have individual sheets for each customer ( the main issue is that visit dates must be documented, whether on indivual sheets of on the same as for all customers. thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
list that alphabetizes itself w/each new name
try following:
put this macro in the worksheet with the list: '-------------------------------- Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 Then '2 means column B Range("B2:B15000").Select Selection.Sort Key1:=Range("B2"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal End If End Sub '------------------------------------------- hope that helps Cheers Carlo "rijisaac" wrote: How do I make a customer list that alphabetizes itself with each new entry? I need to have individual sheets for each customer ( the main issue is that visit dates must be documented, whether on indivual sheets of on the same as for all customers. thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
list that alphabetizes itself w/each new name
Change-event macro ...........
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then Range("A:A").Select Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlYes, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom Range("A65000").Select Selection.End(xlUp).Offset(1, 0).Select End If End Sub hth Vaya con Dios, Chuck, CABGx3 "rijisaac" wrote: How do I make a customer list that alphabetizes itself with each new entry? I need to have individual sheets for each customer ( the main issue is that visit dates must be documented, whether on indivual sheets of on the same as for all customers. thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a List based on your choice from Another List | Excel Discussion (Misc queries) | |||
How to link data from one drop-down list to another | Excel Worksheet Functions | |||
Check 2 different list get associated value from a column | Excel Worksheet Functions | |||
Array formula that alphabetizes a list | Excel Worksheet Functions | |||
Refresh a Validation List? | Excel Discussion (Misc queries) |