Auto fill using drop down list

[alan282]

Hi is there anyway of auto fill a cell from a drop down list, instead od scrolling through the drop down list to select a product.

Lets say I'm entering different type and varieties of fruits in a column. I have all set up in a drop down list but it takes time to scroll through them to select product.

Is it possible to start typing the product in the cell and from the drop down list to pop up at the product I'm typing. Reason is there are different sizes of the same product and scrolling means going through the whole list but if I could start typing and it appears near the product I was looking for it would be quicker, even if I still had to scroll through a few products its better than scrolling through them all.
Example Pink lady apples come in sizes 125, 138, 150, 198, so if I could just type Pink lady and the drop down list appears at Pink Lady 125 and say I wanted 198's I would only have to scroll down to 198.
Hope you get the jist of what I mean and can advise me.

Alan

 

[Norie]

What type of dropdown is it?

If it is a control you'be added to the worksheet then that should happen anyway.

If it's from data>Validation then you'll probably need some code for it.

By the way, have you considered using 2 dropdowns?

One for the main product, eg apple, and another for the size.

The 2nd could be populated based on what is selected in the 1st.

 

[Greg_Davis]

Further explanation please. I also have this, where I have 4 sets of columns with different data and as one is selected, the next has small selection based on first answered and so on.

Also gets rid of all duplication in the pull downs

 

[Heber]

Hi Greg, if you still looking for some solution, I found this usefull, have a look! http://www.youtube.com/watch?v=DxBobxhGKFg