Excel Forum



Excel Magic Trick #171: MACRO Data Validation from 3 lists


Create a MACRO using Relative and Absolute cell references in order to create a Data Validation List from 3 separate lists on 3 separate (different) worksheets.
A good video to watch if you want to see the logic of when to use a Relative Macro and when to use a Absolute Macro.
Also see how to create a dynamic range using a named formula and the OFFSET function.
Also see how to add data Validation list Drop Down Arrow based on a dynamic range using a named formula and the OFFSET function.





Got a Question? Ask it Here in the Forum.