Down to other cells in the column then use absolute column (with ) and relative row (without ) references like Sheet2!B1.
I gave it a name numberbook for windows 7 exporters_list, as you see in the screenshot below.
The Auto Complete would be very helpful though with the number of items involved.The screenshot below illustrates the structure of my table, named exporters_tbl - the fruit names are table headers and a list of exporting countries is added under the corresponding fruit name.To the right in the worksheet use relative column (without the sign) and absolute row (with ) references like Sheet2!B1.If you try and select it again, nothing would happen (as shown below).Close the VB Editor.How is the user to know which they're selecting?
Create a name for the cell containing the first drop-down list.
I really appreciate your help.
Select a cell(s) for your dependent drop-down menu and apply Excel Data Validation again as described in the previous step.
This method won't work if the entries in your main drop-down list contain characters not allowed in range names, such as the hyphen (- ampersand ( etc.
Download the Example File Where to Put the VBA Code Before you start using this code in excel, you need to put it in the back-end, such that it gets fired whenever there is any change in drop down selection.
Add a name for the table's header row (main dropdown) To create a new name that references the table header, select it and then either click Formulas Name Manager New or press Ctrl.Things to remember: The items to appear in the first drop-down list must be one-word entries,.g.To do this, when creating the first dropdown, use a special formula that will check whether any entry is selected in the second drop down menu: IF(B2 Fruit, indirect FakeList Where B2 contains the second dropdown, " Fruit " is the name of the list.Hi aojohnson, you don't need to do anything special.Mango " is selected from the first drop-down list should be named.Your dynamic cascading drop-down menu is accomplished and will update automatically reflecting the changes you've made to the source table.This opens the code window for that worksheet.