Data validation on different sheets?

[Guest]

Hi,

I've noticed that when I try to create a dropdown (Data/Validation/List), it
does not allow me to move to another sheet to select the source of the list.
I'm hoping someone can tell me that I can indeed have a source in a sheet
other than where data entry will take place.

Thanks.

 

[Guest]

When referencing a list from another worksheet the list must be named and the
name used for the source:

=ListValues

Kevin

 

[Guest]

Read this page and all will become clear...

http://www.cpearson.com/excel/named.htm