Data Validation with auto fill

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a cell in a spreadsheet that looks to a data validation list. I would like the program to permit the user to type in that cell and as he types, the program will work through the sorted list and narrow down the possible input data. (Auto Fill?)
 
That is not available in Data Validation. It is available by using VBA and
the Control Toolbox, but that is different than working strictly within
worksheet cells.

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
Rizzo said:
I have a cell in a spreadsheet that looks to a data validation list. I
Click to expand...
would like the program to permit the user to type in that cell and as he
types, the program will work through the sorted list and narrow down the
possible input data. (Auto Fill?)
 
Rizzo
You can do this if each selection from the pull down menu would refer to a seperate secondary list. You can use the selection from the first pulldown as the defined name for the second selection list. Then in the second pulldown use list, and enter =INDIRECT(cell reference of first pull down) as the source

Hope this gets you started

Good Luck
Mark Graesse
(e-mail address removed)

----- Rizzo wrote: ----

I have a cell in a spreadsheet that looks to a data validation list. I would like the program to permit the user to type in that cell and as he types, the program will work through the sorted list and narrow down the possible input data. (Auto Fill?)
 
Back
Top