|
|
Featured Tutorial
Featured Macro
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.
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.