Cross-sheet data validation

One of the annoying limitations of Excel is that Data Validation does not work from one sheet to another. If you have a list of items that you want to use as a pick list for a specific cell, the cell and the list need to be in the same worksheet.

But apparently not. If the list is a named range, and you refer to that named range in the Data Validation, then it can sit in a different worksheet.

Thanks to Lee Smyth for this one.

This entry was posted in Quick tips. Bookmark the permalink.

1 Response to Cross-sheet data validation

  1. Pingback: NT Open Data Days: Exploring data flow in a VCO : Tim's Blog

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.