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
HTH
Ivan
Posted by Paul on January 26, 2002 7:46 AM
Works great. Thanks
