Excel Quickie Playlist: • Excel Quickies
Excel File: https://www.teachexcel.com/exceltuto...
How to make a drop down menu list using data validation and dynamic arrays in Excel 365.
This is a simple procedure, but very easy to forget.
Additional Resources
Dynamic Arrays (msft): https://support.microsoft.com/enus/o...
Data Validation (msft): https://support.microsoft.com/enus/o...
Full Tutorial (where this came from): • Ignore Blanks in Data Validation List...
Excel Courses:
VBA/Macro Course: https://www.teachexcel.com/vbacourse...
Building Professional Forms: https://www.teachexcel.com/premiumco...
Email Course: https://www.teachexcel.com/premiumco...
TeachExcel.com
#msexcel #excelquickie #tutorial