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 |
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 |
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 |
All times are GMT +1. The time now is 08:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com