Data Validation List with Dynamic Arrays in Excel
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.
Procedure
Select the first cell of the dynamic array > put a # at the end of it.
C2#Note: absolute and relative cell references work the same way, there is no change for this.
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tutorial: I will show you 3 ways to remove the blanks from a Data Validation dropdown menu in Excel...
Tutorial: Step-by-step instruction on how to make automatically updating dependent data validation ...
Macro: Add data validation input messages to cells in Excel with this free Excel macro. These mes...
Tutorial: How to use a drop down list (data validation) to create a date in Excel. This technique c...
Tutorial: How to create dynamic charts that update automatically when new data is added to Excel. T...
Macro: List all of the named ranges in a workbook in Excel and the corresponding values store...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)