[算表] 如何連結其他excel工作表的資料
軟體:excel
版本:97-2003
A B C
1 B
2
3 C:\Users\Desktop\4\[b-4.xls]Sheet1'!$B$2
4
5 如何在A1輸入B，公式如上？
6
A B C
1 Ｃ
2
3 C:\Users\Desktop\4\[c-4.xls]Sheet1'!$B$2
4
5 如何在A1輸入C，公式如上？
6
7
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 60.248.19.151
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1426499820.A.0B4.html
→
03/16 18:01, , 1F
03/16 18:01, 1F
→
03/16 18:04, , 2F
03/16 18:04, 2F
→
03/16 18:51, , 3F
03/16 18:51, 3F
→
03/16 18:51, , 4F
03/16 18:51, 4F
→
03/16 18:53, , 5F
03/16 18:53, 5F
→
03/16 18:56, , 6F
03/16 18:56, 6F
→
03/16 19:10, , 7F
03/16 19:10, 7F
→
03/17 13:19, , 8F
03/17 13:19, 8F
→
03/17 13:20, , 9F
03/17 13:20, 9F
→
03/17 13:41, , 10F
03/17 13:41, 10F
推
03/17 19:18, , 11F
03/17 19:18, 11F
→
03/17 19:19, , 12F
03/17 19:19, 12F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
