MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Validation data

Posted by SASA on January 31, 2002 2:39 AM

I am trying to make validation of the cell (drop down list in the cell). It works if with the validation data is in the same sheet. Is it possible to have validation data in other sheet or other workbook.
Thanks in advance for help.

Posted by Antipholus on January 31, 2002 2:55 AM

Yes, but you have to create a Name for the data on the other sheet and then use the Name as the list source.