問題已解決
老師,我想要用Excel9月表里面實(shí)際發(fā)生成本數(shù)據(jù)在主頁那里實(shí)際成本那里自動顯示出數(shù)據(jù),請問老師有什么辦法可以設(shè)置呢?請老師看圖片
![](https://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/014/05/91/38_avatar_middle.jpg?t=1730557491)
使用鏈接的方式,附頁數(shù)據(jù)變動,主頁數(shù)據(jù)跟著變動
2021 09/24 10:59
![](http://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
84784977 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 09/24 11:08
怎么設(shè)置?
![](https://pic1.acc5.cn/014/05/91/38_avatar_middle.jpg?t=1730557491)
家權(quán)老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 09/24 11:11
復(fù)制-選擇性粘貼-粘貼為鏈接
![](http://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
84784977 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 09/24 11:14
我這邊表格沒有看到“粘貼為鏈接”
![](https://pic1.acc5.cn/014/05/91/38_avatar_middle.jpg?t=1730557491)
家權(quán)老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 09/24 11:15
看見選擇性粘貼沒?
![](http://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
84784977 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 09/24 11:19
有看到,只是沒看到粘貼鏈接
![](https://pic1.acc5.cn/014/05/91/38_avatar_middle.jpg?t=1730557491)
家權(quán)老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 09/24 11:21
哦,你使用的是WPS,Excel才有。那你就想其他辦法
![](http://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
84784977 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 09/24 11:23
我用的表就是Excel啊
![](http://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
84784977 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 09/24 11:28
那老師,我現(xiàn)在表WPS有其它方法設(shè)置嗎?或是我要怎么把這個(gè)表專換成Excel
![](https://pic1.acc5.cn/014/05/91/38_avatar_middle.jpg?t=1730557491)
家權(quán)老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 09/24 11:30
下邊還有個(gè)選擇性粘貼
![](http://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
84784977 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 09/24 11:36
也沒看到
![](https://pic1.acc5.cn/014/05/91/38_avatar_middle.jpg?t=1730557491)
家權(quán)老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 09/24 11:42
暈死,你的版本太老了》安裝2007
![](/wenda/img/newWd/sysp_btn_eye.png)