List source must be on same worksheet?

[kiln]

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

 

[Frank Kabel]

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

 

[kiln]

Wow, hits the nail on the head! Thanks!

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