Default Data validation new entry in drop down

[pragnesh_50]

Hi ,


I want two things in my data validation file.


1. My drop down contains many values i want to quickly select values ex. I have values starting with A, B, C, D, X...

I want to select values starting with X by pressing X ... same logic for all the other values.


2.New values in drop down Ex. I have Values A,B,C exist in List I want to add new values say M, i want it to be added in the fixed list of values by having proposal options in the drop down where i can write my new values so that it can be added the list as well as current value.


I hope you all understand it properly and reply it.

 

[Luke M]

Check out Debra's list of examples here:

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


For #1, you might look at "Limit Selection List"

For #2, look at "Flexible Item List"

 

[pragnesh_50]

Hi


could you share you email id so that i can share my file to you.


as i am no voice to micro could you just update my file like that for above two request

 

[Luke M]

I'm afraid I don't share my email on this forum. Debra provides downloadable workbooks...were you not able to just put your data into the template?

 

[pragnesh_50]

Could you check


https://rapidshare.com/files/1048222655/output_Cheese_Adhoc_6160.xls


And do the needful for the above two request

 

[pragnesh_50]

any updates please

 

[SirJB7]

Hi, Pragnesh!


I'm afraid I agree with what NARAYANK991 wrote at this similar topic:

http://chandoo.org/forums/topic/dynamic-search-bar-in-excel-from-partial-input#post-29011

Without user forms, you can't do that: once Excel enters in edit mode, it doesn't process any events until completion of the input process (enter, tab, cursor keys, mouse click off cell, ...).


BTW, looking at your uploaded file, I see that -at least- first columns cell with data validation refers to a list like this (for column F):

=INDIRECT("'800'!A:A")

being 800 the name of the worksheet and the content of column's first row (F1).

So you can unify all the references like this:

=INDIRECT("'"&F$1&"'!A:A")

or with this (if no embedded blanks within worksheet name):

=INDIRECT(F$1&"!A:A")


I think that it'd aid to handle easier the maintenance of the worksheet.


Regards!