Dear All,
Attached excel for your reference.
Sheet Receipts UF has Item Pick-list & Model Pick-list in which Model Pick-list is a dependent pick-list & I even required Search Suggestion for this drop-down list as this list will keep on increasing
So please help me in adding this search suggestion functionality with formulas to this dependent Drop-down list.
Ex: As of now, it works like when I select Down-Rod in Item Pick-list, I get only concerned list in the Model Pick-list. Whereas I want to add one more functionality for this drop-down list i.e., When I start typing the words in the model pick-list, whatever the model has these words should appear in the drop-down list
Another request is that I need this to happen only with formulas, as I'm not much familiar with VBA
I already posted this in Excelforum, link as shown below
http://www.excelforum.com/excel-for...dent-and-search-suggestion-for-a-picklis.html
Attached excel for your reference.
Sheet Receipts UF has Item Pick-list & Model Pick-list in which Model Pick-list is a dependent pick-list & I even required Search Suggestion for this drop-down list as this list will keep on increasing
So please help me in adding this search suggestion functionality with formulas to this dependent Drop-down list.
Ex: As of now, it works like when I select Down-Rod in Item Pick-list, I get only concerned list in the Model Pick-list. Whereas I want to add one more functionality for this drop-down list i.e., When I start typing the words in the model pick-list, whatever the model has these words should appear in the drop-down list
Another request is that I need this to happen only with formulas, as I'm not much familiar with VBA
I already posted this in Excelforum, link as shown below
http://www.excelforum.com/excel-for...dent-and-search-suggestion-for-a-picklis.html
Last edited:
