Selecting Data from a n excel drop down list

By izylifee ·
I have made an excel drop down list from which I enter names into a cell in excel sheet.The list is so long that I have to scroll down to look for the names.
How can I index or authofilter the drop down list so that if I click an alphabet the drop down list will display only names that begin with the alphabet

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -


by LarryD4 In reply to Selecting Data from a n e ...

You will need to house the list in a location hidden to the user, such as a hidden column. And then using VB in Excel pull the data into the drop down list, based on the letter you choose.

I don't beleave their is an easy way to utilize a function to do what you want to do.

Related Discussions

Related Forums