MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Data Validation with list from different Sheet

Posted by Paul on January 26, 2002 6:35 AM

I need to restrict data using a list from a different worksheet since it would not be practical to be the same list in with the data I am using. Excel says the list has to be on the same sheet. Is there a work around or a VBA validation I can use for that column of data?? Thank you

Posted by Ivan F Moala on January 26, 2002 6:54 AM

Use a named range

In your data sheet
Select the range.
Type in the name box a name eg MyDataRange

Use this as your range in the datavalidation list
eg type in =MydataRange



Posted by Paul on January 26, 2002 7:46 AM

Works great. Thanks