Excel Forum



Excel Magic Trick # 259: Dynamic DV List Based On DV List


See how to create a dynamic data validation drop down list based on another dynamic data validation drop down list using excel list / table feature.
Excel 2003 List; Ctrl + L
Excel 2007 Table: Ctrl + T

Also see related video:

YTLE#75: DV Drop-Down based on DV Drop-Down





Got a Question? Ask it Here in the Forum.