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 insertgt;namegt;define, give it a name and refer
to the name like
=MyList
in the list source box will work
--
Regards,
Peo Sjoblom
nwexcelsolutions.comquot;Mikequot; gt; wrote in message
...
gt; Is it possible to use Data Validation where the list of values is on one
gt; worksheet but the dropdown list is on another worksheet? Excel won't let
gt; me
gt; do that.
worksheet but the dropdown list is on another worksheet? Excel won't let me
do that.
If you select the list, then do insertgt;namegt;define, give it a name and refer
to the name like
=MyList
in the list source box will work
--
Regards,
Peo Sjoblom
nwexcelsolutions.comquot;Mikequot; gt; wrote in message
...
gt; Is it possible to use Data Validation where the list of values is on one
gt; worksheet but the dropdown list is on another worksheet? Excel won't let
gt; me
gt; do that.
文章標籤
全站熱搜
