Forum Discussion
Dependent (secondary) drop down lists
I've recently seen a few posts on various sites with people requiring assistance in devloping dependent drop downs. For example drop down box A contains Tea, Coffe, Juice If you select Coffe...
I have created several tutorials on this topic which can be found here - http://www.contextures.com/excelfilesRoger.html For those with XL2007 upward, I would recommend the use of Tables see DV004 and DV005 For earlier versions (and working in all versions of Excel) there are examples using named ranges with Index see DV002 and DV003