![]() in the first list only displays Managers for that selected department in the second list. In our main table on the left, we want to have two picklists in each row, so that selecting a Dept. Source dataįor starters, let's get some source data to work on. ![]() In pre-dynamic versions of Excel, please use the traditional approach to creating multiple dependent drop down lists. Important note! Because this solution relies on the dynamic array feature, it is only applicable in Excel for Microsoft 365 and Excel 2021.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |