Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down box leading to another drop down box
I have a cell containing a drop down box with three options. Can i design my
worksheet so that when one option is selected a drop down box in the neighbouring cell appears with a number of options in it? Each of the original 3 options in the first drop down box needs to lead to a different list in the second drop down box, though the options can be repeated. Any help would be much appreciated. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down box leading to another drop down box
stumakker, have a look here and see if this will work for you,
http://www.contextures.com/xlDataVal02.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "stumakker" wrote in message ... I have a cell containing a drop down box with three options. Can i design my worksheet so that when one option is selected a drop down box in the neighbouring cell appears with a number of options in it? Each of the original 3 options in the first drop down box needs to lead to a different list in the second drop down box, though the options can be repeated. Any help would be much appreciated. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down box leading to another drop down box
brilliant!!
thanks for the help "Paul B" wrote: stumakker, have a look here and see if this will work for you, http://www.contextures.com/xlDataVal02.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "stumakker" wrote in message ... I have a cell containing a drop down box with three options. Can i design my worksheet so that when one option is selected a drop down box in the neighbouring cell appears with a number of options in it? Each of the original 3 options in the first drop down box needs to lead to a different list in the second drop down box, though the options can be repeated. Any help would be much appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
formulas for drop down menus | Excel Discussion (Misc queries) | |||
How do I set up a drop down menu within a drop down menu? | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions |