Dynamic Drop-Down List

You may be familiar with creating a drop-down list in Excel using the Data Validation feature. But here's how you could create a drop-down list that changes depending on what's in another cell.

Click the link below to download a copy of the file that I used in the video:

Dynamic Drop Down.xlsx

Download XLSX • 10KB