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.