★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy
★ Get the example file ★
Sign up for our free Insiders program and get the example file:
https://exceloffthegrid.com/insiders-signup/
File Reference for this video: 0234 Dependent drop-down lists.zip
★ About this video ★
In this video, we are looking at the easiest method for creating dependent drop-down lists in Excel.
It's a simple method using range functions. So, let's get started.
0:00 Introduction
0:16 Scenario
0:57 Creating dynamic ranges
2:25 Drop down list
2:59 Range functions
3:25 Dependent drop-down lists
6:14 Multi-level dependent drop-down lists
8:08 Wrap-up
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: https://twitter.com/exceloffthegrid
#MsExcel