Excel Forum
Excel VBA Course
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

Dynamically Update a Drop Down Menu/List

This Excel video tutorial shows you how to create a dynamically updating drop-down list or menu in excel. The drop-down menu is created through data validation and this tutorial assumes that you already know how to do that. Once you have a drop-down menu, one of the biggest problems that people run into is how to make this menu or list automatically update when another value or word or phrase is added to the list. And, this tutorial shows you how to fix that problem using the OFFSET() and COUNT() functions. This is a really useful tutorial and you can modify what's learned here to make many other lists or menus in excel dynamic.
   Topics Covered
Create Dynamically Updating Lists/Menus in Excel
Automatically Update a Drop-Down Menu when More Values or Items etc. are added to the list.
OFFSET() Function
COUNT() Function
   Difficulty:         Intermediate
   Video:               Yes

Got a Question? Ask it Here in the Forum.