Software

Ask something
Question Locked

Selecting Data from a n excel drop down list

0 helpful
2 replies

by izylifee

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

by larryd4

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.

This discussion is closed to new replies.