In the attached EXCEL file:
1- The drop down list in column B depends on the choice in the drop down list in column A.
2- The drop down list in column B, then uses searchable drop down list as defined in Tab "Menu".
3- On cell B2, you can enter any partial text, which causes selective menu items which contain this partial text to be created on the "Menu" tab. Which in turn is displayed when clicking the drop down list in cell B2.
4- The above scenario is working fine on cell B2, but I do not know how to apply the same scenario in all the Cells in column B.
Appreciate any suggestion on how to achieve the above.
Thank you
