Excel Forum
Similar Content
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
Combine Data from Multiple Worksheets in Excel
Tutorial: The easiest way to combine and consolidate data in Excel. Simple method to combine data ...
Insert and Manage Page Breaks in Excel
Tutorial: How to insert, remove, and manage page breaks in Excel.  This can be rather annoying and...



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.