Excel Data Validation Drop Down Lists are great for ensuring data is entered uniformly and is easy to work with. In this video I cover various ways to set up drop down lists so they dynamically update as new data is added to the source list. PLUS how to get searchable drop down lists without upgrading Excel!

Download the Excel file here: https://www.myonlinetraininghub.com/e...

View my comprehensive courses: https://www.myonlinetraininghub.com/

Connect with me on LinkedIn:   / myndatreacy  

0:00 Excel Drop Down Lists aka Data Validation Lists
0:28 Creating Drop Down Lists
3:00 Dynamic Updating of Lists on same sheet
4:15 Dynamic Updating of Lists on different sheet
6:41 Dynamic Array as List source
8:21 Searchable Drop Down Lists