Data Validation with auto filter

[ppp1812]

Hi,

I hve a data validation list of over about 100 items in it. Most of the time it gets very cumbersome to select from this list.

Can some one please help me by telling me how can i do this the way we search in Google ....... as soon as we start typing anything a list opens up and as we go on typing the list automatically gets filtered to the closest available options.

What I want is that as soon as we select the cell where we want to enter the data and start typing ............... the data validation list should open up and start getting filtered as we go on typing ............. same as we do in Google......

Hope the above is clearly understandable.

Thanks

 

[SirJB7]

Hi, ppp1812!
That feature is only available in userforms or list / combo controls, not for drop down validation lists for cells.
Regards!

 

[ppp1812]

Hi, ppp1812!
That feature is only available in userforms or list / combo controls, not for drop down validation lists for cells.
Regards!

Hi SirJB7,

Thanks ............ but can you please tell me how the same can be used for above mentioned purpose of data validation.
And also how the list can be opened if the cell is selected.

Regards

 

[SirJB7]

Hi, ppp1812!
I'm afraid I won't be able to help you until middle of next week. If I happen to find the required time I'll try to post sooner.
Regards!

 

[Smallman]

Hi Prakash

As already mentioned this feature is not available for Data Validation lists. It is however available for comboboxes and there is a work around. Debra Dalgleish has a example file on her site which is a handy starting point. I had to build something for a client once and used to get me going. It required a fair bit of error trapping in the end to get it working well. But the below should give you an idea of what is possible.

http://www.contextures.com/xlDataVal10.html

Take care

Smallman

 

[jeffreyweir]

Another option:

http://www.excelhero.com/blog/2010/07/excel-partial-match-database-lookup.html

Read down until you see the first UPDATE because this covers a great approach from my good pal Sam on using the advanced filter

 

[Stephan]

Hi I've made a Generic Data Validation all in Formula.
Copy & paste your data into DATA tab, Columns A-F are categories searched.
use SEARCH tab to filter through your data via the Combo Boxes.