close

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.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄