MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Validation data


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

Hi,
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.
Regards
Sasa


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.