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

List source must be on same worksheet?
 

Hi
try the following:
- create a defined name for your list (goto 'Insert - Name - Define')
- use this name as data source within the data validation dialog

also have a look at
http://www.contextures.com/xlDataVal05.html

--
Regards
Frank Kabel
Frankfurt, Germany

"kiln" schrieb im Newsbeitrag
om...
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

List source must be on same worksheet?
 

Wow, hits the nail on the head! Thanks!

In article ,
says...
Hi
try the following:
- create a defined name for your list (goto 'Insert - Name - Define')
- use this name as data source within the data validation dialog

also have a look at
http://www.contextures.com/xlDataVal05.html

--
Regards
Frank Kabel
Frankfurt, Germany

"kiln" schrieb im Newsbeitrag
om...
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