top of page
  • Writer's pictureNick

Dynamic Drop Down Lists

Updated: Oct 30, 2022

Start from scratch:

Dynamic Drop Down Lists
.xlsx
Download XLSX • 342KB

Finished file:

Dynamic Drop Down Lists Finished
.xlsx
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

Comentarios


bottom of page