LinkBack URL
About LinkBacks
create a simple drop down list and search by first few letters (non vba or macros)
create a simple drop down list and search by first few letters (non vba or macros)
select the column, then click Data->Filter
Can't do it if you're talking about typing your letters into the dropdown menu but if you can type them into a separate cell...
Original List in A2:A18, I created a defined name "names"=A2:A18
Then in B2 copied down
where D1 is the cell where you will enter your letters.Formula:
Please Login or Register to view this content.
Created a dynamic defined name called "names2"
Formula:Please Login or Register to view this content.
Data Validation > List > =names2
Voila!
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
ChemistB...Thanks for your help, however, I need to type the first few letters into the drop down, then make my selection from the "short list".
Richard
Okay, then you'll have to either use a different program or wait until the year 2030 when Excel makes that part of it's functionality.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks