| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
drop down menu
I would like to have a drop down menu option for a cell.
However, the choices will determine what data is entered into another cell. For example: menu options X Y Z, if user picks X then 12 goes into cell d35, 13 goes into d36 and 14 goes into d37. If option Y is chosen, then 11 goes into d35, 34 goes into d36 and 54 goes into d37 and so on ... Thanks in advance for your assistance. Susan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
drop down menu
Susan,
Select the cell and goto Data Valiadation under Allow: select List under Source type X, Y, Z Check out all the other options and make any selections you want. If your validation cell is D34 In D35 =If(D34="X",12,If(D34="Y",11,If(D34="Z",10,""))) Put similar formulas in D36 and D37. Note that the final option is "" so that these cells remain blank if nothing is selected. steve "Susan April" wrote in message ... I would like to have a drop down menu option for a cell. However, the choices will determine what data is entered into another cell. For example: menu options X Y Z, if user picks X then 12 goes into cell d35, 13 goes into d36 and 14 goes into d37. If option Y is chosen, then 11 goes into d35, 34 goes into d36 and 54 goes into d37 and so on ... Thanks in advance for your assistance. Susan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
drop down menu
Steve, Thanks...That's it.....this should work. Susan *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
drop down menu
Susan,
You're very welcome! Glad I could help. steve "Susan April" wrote in message ... Steve, Thanks...That's it.....this should work. Susan *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down Menu | New Users to Excel | |||
| Drop Down choice needs to lead to another drop down menu | Excel Discussion (Misc queries) | |||
| Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
| filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
| Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions | |||
Linear Mode
