|
|
Featured Tutorial
Featured Macro
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 |