Excel Forum
Similar Content
Remove All Data Validation from a Cell in Excel
Macro: Remove all data validation from a cell in Excel with this free Excel macro. This is a grea...
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...
Add a Drop Down Menu to a Cell in Excel - Data Validation Macro
Macro: Add a drop down menu or list to a cell in Excel with this free Excel macro. This is a grea...



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.