How to get Drop down list/Customs List with auto-complete feature

[gssachin]

Hi,
I have around 100 carders which is located in Sheet (“Master Carders List”)

And I have to apply some carders to around 200 rows (employees) in Sheet 1 (“G” Column, Starting G3:G200) .
Since User should not make any spell mistake or make new carder for that I want to restrict them to use carder in “Master Carder List”.

I tried data validation “Custom List” option but its time consuming task to select correct cadre out of 200 cadres .
Therefore I required “Custom List” with “Auto-Complete” Feature so we can save time for users.

Thanks in advance.

 

[Jmy85]

You are welcome.

I am looking to do something similar but I need the dynamic search to be replicated on multiple sheets pulling from the same list. The excel is a recipe book pulling data from a market list into a recipe card for costing. I have a link to the book here:https://vsag.box.com/v/Menubook

I need it to be easy to use for people who are not excel savvy as most of my guys using it will be chefs with little formal education. Do you have any recommendations?

 

[gssachin]

Dear Sir,

Can we use wild cards i.e. "*" to search from drop-down list.