Title:
Excel Magic Trick #171: MACRO Data Validation from 3 lists
Video:
Description: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.
Published:
31/Dec/2008
Excel Magic Trick #171: MACRO Data Validation from 3 lists
Video:
Description: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.
Published:
31/Dec/2008
No comments:
Post a Comment