HOW DO I SET UP DROP DOWN CELLS TO AUTO FILL AS I START TYPING IN.

[Guest]

I have dropdown cells set up which draw from a list on another worksheet, I
am trying to set it up so that when I start to type within the cell it will
strat filling from the list.

 

[Guest]

if you have a list hidden directly above your input cell as you type excel
will fill in from the list above.

 

[broro183]

Hi Trenner,

Have a look at Debra's pages:

The start (for background info),
http://www.contextures.com/xlDataVal01.html

useful page,
http://www.contextures.com/xlDataVal10.html

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...