How do I create a validation list on a separate worksheet?

[Debra Dalgleish]

If you name the range that contains the validation list, you can refer
to it on another sheet. There are instructions here:

http://www.contextures.com/xlDataVal01.html

Ronaldo wrote:

 

[Gord Dibben]

Ronaldo

Name the List source.

Insert>Name>Define.

Use that name in your source for the List in DV.

For more on this.......

Debra Dalgleish's site

http://www.contextures.on.ca/xlDataVal05.html

Gord Dibben Excel MVP