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.