software

Hi !

I need to make a dropdown menu..
In attachement I have two columns..

I want to make dropdown menu in B1.. and to choose between options B2 -
B16.. and when I make a choice.. I want my choice te show up in E1 (from
B column) and F1 (from D column)

Thanks a lot -------------------------------------------------------------------
|Filename: quest 1.zip |
|Download: www.excelforum.com/attachment.php?postid=4256 |
-------------------------------------------------------------------

--
alen_re
------------------------------------------------------------------------
alen_re's Profile: www.excelforum.com/member.php...oamp;userid=28331
View this thread: www.excelforum.com/showthread...hreadid=503850data validation(allow list) or combo box from from toolbar.depending on what
you want to show in your second output(F1) use a lookup or choose,index etc
to .People wont always use your attatchment(it didnt work btw),describe in
your post what you have/want
--
paul
remove nospam for email addy!
quot;alen_requot; wrote:

gt;
gt; Hi !
gt;
gt; I need to make a dropdown menu..
gt; In attachement I have two columns..
gt;
gt; I want to make dropdown menu in B1.. and to choose between options B2 -
gt; B16.. and when I make a choice.. I want my choice te show up in E1 (from
gt; B column) and F1 (from D column)
gt;
gt; Thanks a lot
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: quest 1.zip |
gt; |Download: www.excelforum.com/attachment.php?postid=4256 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; alen_re
gt; ------------------------------------------------------------------------
gt; alen_re's Profile: www.excelforum.com/member.php...oamp;userid=28331
gt; View this thread: www.excelforum.com/showthread...hreadid=503850
gt;
gt;