Dependant Dropdown Lists or another way?

Hello all,

I need some assistance on which method I should for my excel sheet. I have a data capture sheet that I'm creating and I have a list of 3,000 Business Owners that I'd like to select from. But, rather than having one LONG list of 3,000 Business Names listed, I'd like to "group" them and make the 'selection' process for my folks a little easier.

So, I'm thinking that I could use a dropdown using the first letter of the business name so that it limits it to 26 options. Then, I'd have all of the Businesses with a name starting with "A" or whatever. Then, once you go down the list of Business Names, I was thinking of creating another dependant dropdown with the Locations of the Businesses.

All in all, I'd like to capture the business name along with the business location in a way where my folks that are capturing the data do not have to type out the data.

Is this the smartest way to do it? Or, is there another way to process this that makes more sense?

Hi ArnyVee,

From past experience(and I have made countless number of data capture sheets ), I would consider having two dropdown lists, first dropdown would have all group names, and the second dropdown would have all items that are grouped under the selected group name.

however I would for this use a little bit of VBA for ease, altho im not sure how easy it would be to do with out VBA.

Hope this helps in some way,