Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can I autopopulate from a long drop down list in Excel?
I have a very long list of referring physicians in a drop down list for data
entry people to populate. I would like them to type in the first 3 characters and be immediately directed to that area of the drop down list. Is this possible? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can I autopopulate from a long drop down list in Excel?
Instead of the dropdown.
This will take you to the name in col J Sub gotonfirst3letteredname() myname = InputBox("Enter first 3 letters of name") If Len(myname) < 3 Then MsgBox "THREE letters" Exit Sub End If Columns("J").Find(What:=myname, After:=Range("j1"), _ LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, _ SearchDirection:=xlNext, MatchCase:=False).Activate End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "seve" wrote in message ... I have a very long list of referring physicians in a drop down list for data entry people to populate. I would like them to type in the first 3 characters and be immediately directed to that area of the drop down list. Is this possible? Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can I autopopulate from a long drop down list in Excel?
No, you can't. Not in the way you want it to work. Don gave you a way to
do it not using a drop-down list. There is a way to give you somewhat what you want, though, and still use a drop-down list.. Obviously, you have your listing in alphabetical order. Go to that list. Looking at only the first letter of the name, say "C", insert a blank cell in your list immediately above the first "C" name. Type "C" (without the quotes) into that blank cell. Do that for every letter in the alphabet. Setup your Data Validation cell using that new list. Now, if the user types (into the Data Validation cell) the first letter of the name he is looking for, and clicks on the drop-down arrow, the drop-down will shift to that letter. Does that help? HTH Otto "seve" wrote in message ... I have a very long list of referring physicians in a drop down list for data entry people to populate. I would like them to type in the first 3 characters and be immediately directed to that area of the drop down list. Is this possible? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Drop Down/ Autopopulate | Excel Worksheet Functions | |||
Quick Find in long drop down list | New Users to Excel | |||
Drop down menu with emp name then autopopulate with supervisor... | Excel Discussion (Misc queries) | |||
Autopopulate a drop down list in Excel | Excel Discussion (Misc queries) | |||
Help with Excel - autopopulate a long table based on infor from an | Excel Discussion (Misc queries) |