EXCEL PRO TIP: Dependent Drop-Downs with INDIRECT

[@wayneedmondson1065]

Hey Chris.. nice review of what I did inside the Pro Tips course. You might want to mention that if the list sources for the drop downs are turned into individual Excel Tables, then the drop downs will become dynamic when new items are added to the list. I guess the new Dynamic Array Functions of UNIQUE, SORT and FILTER will make quick work of these proven techniques. I assume (and hope) that the list source will allow for the reference to a SPILLED array with the use of #. Thanks and Thumbs up!

[@ExcelMaven]

Thanks Wayne, the new dynamic arrays are great -- hoping to add some new tips on those soon!