Data Validation - autofill

B

Bryan Bloom

I have a spreadsheet with a range of data that is validated into a list for a drop down box. Then I am able to select within the list. Fine.

BUT does anyone know how to set this so that you dont have to use the drop down box, ie. so that you can start typing and the closest match in the list will appear. As you type, the match gets closer until you use the return key or pick from the list.

If anyone knows how to do this, please HELP! And thanks.

Bryan Bloom
[email protected]
 
N

Nick Hodge

Bryan

This is not a feature of data validation. It is a feature of a range that
when you start to enter an entry already in the 'list' it completes it for
you.

I short DV doesn't do exactly what you want

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]


Bryan Bloom said:
I have a spreadsheet with a range of data that is validated into a list
Click to expand...
for a drop down box. Then I am able to select within the list. Fine.
BUT does anyone know how to set this so that you dont have to use the drop
Click to expand...
down box, ie. so that you can start typing and the closest match in the list
will appear. As you type, the match gets closer until you use the return
key or pick from the list.
 
B

Bryan Bloom

Thanks Nick - now I am going in the right direction. But. Can you give some more information on how to do this. Say you have the list in a group of cells, then what? Is there a particular formula?

Bryan
 
B

Bryan Bloom

Thanks JE - but I had little luck finding the help you describe. It keeps coming upwith how to do autofill of a series. What I am trying to do isnt a series.

I have a huge list of items in rows. Below that I want to be able to do a quote sheet based on the items above. I can use the Lookup formulas except for the initial cell entry I need to be able to have the user start typing the item number and then the corresponding item from the list above begins to appear until you select the item. Does that make sense?

Thanks

BB
 
J

JE McGimpsey

Your version of Help's index may be different - try searching on
AutoComplete.
 
Top