Excel Forum



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.