Excel Forum



Excel Magic Trick 774: Dynamic Data Validation AND Dependent Data Validation Together


Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
A great trick from http://www.contextures.com/xldataval02.html#Dynamic
To create a Dynamic Data Validation AND Dependent Data Validation Together using Defined Names, OFFSET function, INDIRECT function and more.





Got a Question? Ask it Here in the Forum.