Wanting to create a drop down list and select a value from a range of cells? This quick, simple video will reveal how you can take data validation to the next level. Instead of having a fixed source range that your drop down list retrieves from, this method will allow you to add values to a range and Excel will automatically update the drop down list to incorporate those new values.
How to Create a Dynamic Drop Down List in Excel
Updated: Nov 14, 2019