Data Validation Lists

Is it possible to use Data Validation where the list of values is on one
worksheet but the dropdown list is on another worksheet? Excel won't let me
do that.

If you select the list, then do insert>name>define, give it a name and refer
to the name like

=MyList

in the list source box will work

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Mike" <Mike@discussions.microsoft.com> wrote in message
news:096326F1-E808-4D0E-BC23-7E2D7838C594@microsoft.com...
> Is it possible to use Data Validation where the list of values is on one
> worksheet but the dropdown list is on another worksheet? Excel won't let
> me
> do that.