MrExcel Publishing
Your One Stop for Excel Tips & Solutions

In Data Validation how can i pick from list on another sheet...?


Posted by Phil on July 09, 2001 9:29 AM

Does any1 know how i can use Data Validation to pick from list on another sheet...?


Posted by lenze on July 09, 2001 9:37 AM

Name your list (source) and then refer to the name in the data validation form. Your entry would be =source