| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down menu
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: http://www.excelforum.com/attachment.php?postid=4256 | +-------------------------------------------------------------------+ -- alen_re ------------------------------------------------------------------------ alen_re's Profile: http://www.excelforum.com/member.php...o&userid=28331 View this thread: http://www.excelforum.com/showthread...hreadid=503850 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down menu
data 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! "alen_re" wrote: 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: http://www.excelforum.com/attachment.php?postid=4256 | +-------------------------------------------------------------------+ -- alen_re ------------------------------------------------------------------------ alen_re's Profile: http://www.excelforum.com/member.php...o&userid=28331 View this thread: http://www.excelforum.com/showthread...hreadid=503850 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hyperlinks in drop down menu | Excel Worksheet Functions | |||
| hyperlinks in drop down menu | Excel Worksheet Functions | |||
| Help with drop down menu | Excel Worksheet Functions | |||
| How to create a drop down menu which referencing a different workb | Excel Discussion (Misc queries) | |||
| How do I set up a drop down menu within a drop down menu? | Excel Discussion (Misc queries) | |||
Linear Mode
