List source must be on same worksheet?
This is such a terrible limitation... isn't there any way around it? I
have a list that could be used on many worksheets, and if I have to
copy/paste link it to all of those pages, it'll be a maint headache. I'm
using the list(s) for Data/Validation lookups.
Thanks
|