Data validation on different sheets?
 

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.

Data validation on different sheets?
 

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

=ListValues

Kevin

Data validation on different sheets?
 

Read this page and all will become clear...

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

Jim Thomlinson


"ppsa" wrote:

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.