Hello
I have a drop down list done with the help of data validation it contains around 150 SKU's. Is there by chance any way through which i could convert that into a searchable drop down list for example if i type "A" all the items starting with A should be displayed which i can navigate through up/down keys or click with the mouse. Please note: I would be needing this in a bunch of places in the same sheet like say i need this between A1:A100
I have a drop down list done with the help of data validation it contains around 150 SKU's. Is there by chance any way through which i could convert that into a searchable drop down list for example if i type "A" all the items starting with A should be displayed which i can navigate through up/down keys or click with the mouse. Please note: I would be needing this in a bunch of places in the same sheet like say i need this between A1:A100