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.


Excel Function: INDIRECT()
Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course

(35% Sale Ends Jan. 26)

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.)

View Course (35% Discount)

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...
Make Quick Lists for Drop Down Menus - Save A LOT of Time
Tutorial: Quickly make data validation drop down lists (menus) in Excel. This method is simple, onl...
Dependent ComboBox Drop Down Menus
Tutorial: How to create UserForm drop-down menus that change based on what was selected in another d...
Vlookup Date Picker in Excel (Dynamic)
Tutorial: Make a dynamically updating vlookup date picker for excel that allows you to choose a date...
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 ...
Tutorial Details
Excel Function: INDIRECT()
Downloadable Files: Excel File
Excel VBA Course

(35% Sale Ends Jan. 26)

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.)

View Course (35% Discount)