software

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.

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

remove nospam for email addy!
quot;Trennerquot; wrote:

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


Hi Trenner,

Have a look at Debra's pages:

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

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

hth
Rob Brockett
NZ
Always learning amp; the best way to learn is to experience...--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=542310