Automatically Updating Dependent Drop Down List Menus in Excel

Add to Favorites
Author: | Edits: don

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.

Question? Ask it in our Excel Forum

Excel Function: INDIRECT()
Downloadable Files: Excel File

Similar Content on TeachExcel
Make a Drop Down List Menu in a Cell in Excel
Tutorial: I'll show you how to make a drop down list menu in a cell in Excel. This allows you to ha...
Dependent ComboBox Drop Down Menus
Tutorial: How to create UserForm drop-down menus that change based on what was selected in another d...
Add a Drop Down Menu to a Cell in Excel - Data Validation Macro
Macro: Add a drop down menu or list to a cell in Excel with this free Excel macro. This is a grea...
Using Formulas with Tables in Excel
Tutorial: Easy way to reference data tables and make formulas within a data table. This allows you ...
Dynamic Named Range in Excel
Tutorial: How to create a named range that expands automatically when a new value is added to the r...
Easily Compare Duplicate Values in Excel
Tutorial: Here, I'll show you a simple technique to quickly and easily compare large lists of duplic...