Dear Friends,
Appending a file where in sheet1 In Column A & Column C I need drop down list with searchable option without VBA.
I have list of fruits in "fruits" sheet.
Suppose in A2 when drop down list will appear there will be a search option with keyword search. If I write "apple" all words with apple will appear in drop down list, thereafter I shall select any one of those.
Please help.
Thanks in advance
Regards
TPR
Appending a file where in sheet1 In Column A & Column C I need drop down list with searchable option without VBA.
I have list of fruits in "fruits" sheet.
Suppose in A2 when drop down list will appear there will be a search option with keyword search. If I write "apple" all words with apple will appear in drop down list, thereafter I shall select any one of those.
Please help.
Thanks in advance
Regards
TPR