Create a Smart Drop Down Auto Suggestion List in Excel
$35
Delivery in
4 days
Response time
Instantly
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
Explore the marketplace!
What you get with this Offer
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
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 Offer Add-ons
-
I can deliver all work in 1 working day
+$10
What the Freelancer 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
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies