MM0001 - 02/12/19 - How To Create Dynamic Dropdown Menus

Excel Dropdown menus are cool - but how to maintain them properly?  In this stream, we show how to create 'dynamic' dropdown menus that update when you add new entries to the list.  So, no more dropdowns with a list of empty spaces at the bottom!

Download the files here.

Topics
  •  | Dynamic Dropdown Menus - Setup
  •  | RIGHT
  •  | Basic Dropdown Menu
  •  | Time Formatting
  •  | Dynamic Dropdown Menus - Concept
  •  | Dynamic Dropdown Menus With OFFSET
  •  | Named Range Naming Conventions
  •  | MATCH
  •  | COUNTA
  •  | IF
  •  | OFFSET
  •  | Write Down Assumptions
  •  | TEXT
1 Lesson