這個(gè)問題，其實(shí)就是一個(gè)跨工作表使用數(shù)據(jù)有效性的問題。

數(shù)據(jù)有效性，只能跨工作表使用，是無法跨工作簿使用的，怎么用呢，就是通過定義名稱。

具體操作看視頻，希望對(duì)你有用。

{!--PGC_VIDEO:{"thumb_height":360,"file_sign":"22a2cf7d8672dfc8c138fd944c5411ab","vname":"","vid":"f65ff975f47742758e4dc845830bfa30","thumb_width":594,"vu":"f65ff975f47742758e4dc845830bfa30","src_thumb_uri":"713f000ac655e4dc19c6","sp":"toutiao","update_thumb_type":1,"vposter":"https://p3-sign.toutiaoimg.com/mosaic-legacy/6ef3000910335fec9ce5~noop.image?x-expires=1994925951&x-signature=wqpDQxwkp3PcJRmu3e8tjjbZR3A%3D","video_size":{"high":{"duration":239.9,"h":480,"subjective_score":0,"w":792,"file_size":2765143},"ultra":{"duration":239.9,"h":720,"subjective_score":0,"w":1190,"file_size":3501259},"normal":{"duration":239.9,"h":360,"subjective_score":0,"w":594,"file_size":2500770}},"duration":239.9,"thumb_url":"6ef3000910335fec9ce5","thumb_uri":"6ef3000910335fec9ce5","md5":"22a2cf7d8672dfc8c138fd944c5411ab"}--}

如果有用請(qǐng)點(diǎn)贊，還有想法請(qǐng)留言補(bǔ)充。