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