Data Validation - autofill

[Guest]

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
(e-mail address removed)

 

[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
(e-mail address removed)

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.

 

[Guest]

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

 

[JE McGimpsey]

Take a look at "Quickly fill in repeated entries in a column" in XL Help.

 

[Guest]

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

 

[JE McGimpsey]

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