Select a region name in one Excel drop down list, and then select an employee from that region, in the next drop down list.
This example uses new Excel functions, UNIQUE, SORT, and FILTER, to create dynamic arrays for the lists used in the drop downs.
To get the free workbook for this video, go to my Contextures website:
https://www.contextures.com/exceldatavaldependdynamic.html
Video Timeline:
0:00 Introduction
0:31 Create a Unique List of Regions
2:38 Make a Region Drop Down
3:30 Create an Employee List
5:50 Make an Employee Drop Down
7:35 Get the Workbook
Instructor: Debra Dalgleish, Contextures Inc.
Get Debra's weekly Excel tips: http://www.contextures.com/signup01
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextures?sub_confirmation=1
#ContexturesExcelTips
