Main Profile

At A Glance

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.
Length: 10:56

Contact

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

Want more info about Excel Magic Trick #171: MACRO Data Validation from 3 lists? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question