What it does
It applies the list data validation type with a reference to a named range for any selected cell(s) in the active sheet.  If the clipboard contains text, it is used as the default (expecting it to be the range name).

When to use it
When you want to apply list-based data validation and the source of that list is a named range, this is a quick and consistent way to do it.

Why to use it
It’s an efficient way to apply a specific but common data validation type, especially when used in conjunction with named range macros.

Default shortcut
None

Other Details

• Category: Data / Content
• Difficulty: 4/5
• Usage/frequency: 3/5
• Automation factor: 4/5 (estimated 30 seconds saved each time used)
• Type: Shortcut
• Date added: 3/10/2018
• Tags: Data validation, list, named range, value

Related Macros
Add Dynamic Named Range
Data Validation Picker
Bulk Data Validation
Search Data Validation List

Other Articles
None

None

Prerequisites
Set a named range to a list that should be the source for data validation, then identify the cell(s) you want to apply a list-based data validation to.  The list and cell(s) containing the data validation settings do not have to be in the same worksheet but do need to be within the same workbook.

Instructions
After you have set/identified a named-range based list and identified the cell(s) to apply the data validation list to, run the Add Data Validation From Named Range macro.  It will prompt you for the named range that contains the data validation list.  This named range will be referred to.  If your clipboard contains text (based on copying the named range), it will be defaulted for you – this is highly recommended to prevent errors.  After entering the range name or accepting the default, if the range name is valid, the data validation list will be applied to all selected cell(s).  That’s it!