Create a Smart Drop Down Auto Suggestion List in Excel

Delivery in
2 days
Response time

  • Views 284
  • 1
  • 1

What you get with this Hourlie

Maybe you already know that you can't have an auto suggest list when you're using basic data validation list. But you can have auto suggest with a combobox. so, here goes a pop up combo box list.

But, you want to have a dependent data list, and yes it's possible using both data validation list and combo box list

Requirement :
- excel VBA enabled (.xlsm)
- excel version 2010 +
- windows version (not Mac)
- Will need a specific sheet to store this database list

This method, suite you if :
- you can have a dynamic dependent data combo box*
- you either have or don't have a dependent data list
- you have a bunch of list approx. more than 100 lists

This method can be combined with :
- data validation list

*For dependent data validation list, it can't be dynamically updated of each list, but combobox can. so for only this feature, you can only use combobox pop up list

Get more with Hourlie Add-ons

  • I can deliver all work in 1 working day

What the Seller needs to start the work

1. Contact me through PPH Chat & messages
2. Discuss your case, best with sharing screen call via skype
3. Agreed upon the price, deadline, other agreements
4. Start cracking