top of page
  • Writer's pictureNick

Dynamic Drop Down Lists

Updated: Oct 30, 2022

Start from scratch:

Dynamic Drop Down Lists
Download XLSX • 342KB

Finished file:

Dynamic Drop Down Lists Finished
Download XLSX • 350KB

If you've ever created a dashboard in Excel, you've probably added Data Validation drop down lists for selectors. Once you start to add a few in that may relate to each other, you'll find that it would be nice if each list reduced to only the applicable items based on the choices from the other selections. In this video, we'll look at how to make that happen! You'll need dynamic arrays (Office 365) for this.

61 views0 comments

Recent Posts

See All


bottom of page