How to Base one drop down list on another in Microsoft Excel
Excel dilettantes and seasoned Microsoft Office professionals alike may be surprised to learn that in Excel one can make a drop down list based upon a second drop down list (or, similarly, data validation list that is based on a second validation list).
See how to create a Drop Down List that is based on another drop down list using there
1)Data Validation List
3)Create Names From Selection