Define a Validation List Using a Name

Feb 23, 2013

When creating a validation list, it is often neater to store the source of the list on a separate worksheet, away from the main data. In Excel 2007 and earlier, you can’t store the “list source” on a different sheet to where the list will be used,...