Step-by-step instruction on how to make automatically updating dependent data validation drop down menu lists in Excel - these lists are made to update automatically when new data is added to a table that is on the same worksheet or another worksheet.
This tutorial combines Data Validation with Tables and the INDIRECT() function in Excel in order to create dynamic drop down lists that automatically add new data to them when your source data has been updated and added to.
The features in this tutorial are not that difficult to understand and I show you every step of the process so that you can set this up for your own data set.