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.

Regards,
Prangnesh

 

[AlphaFrog]

1.) Data Validation lists do not support Auto-Complete. Here is one way around that...
Excel Data Validation Combo box


2.) You could used a Dynamic Named Range to add items to the list
Excel Names -- Excel Named Ranges

 

[pragnesh_50]

Could you guys check

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


And do the needful for the above two request in the file.

 

[wigi]

Could you guys check

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

And do the needful for the above two request in the file.

Please respond to the help that was given to you above.
Then AlphaFrog and other users have better information to target this.

 

[pragnesh_50]

could you please check?

 

[pragnesh_50]

any upadtes please

 

[wigi]

You have been given help earlier.
Without effort from you, other helpers (volunteers) are not very likely to help you again.