Excel file

2008-01-21 8:16 pm
組合數份Excel files,把其中數項資料插入同一個總結表內,請教如何做

回答 (1)

2008-01-21 9:49 pm
✔ 最佳答案
eg: A1 =[Book2]Sheet1!$A$4+[Book3]Sheet1!$A$3

Book2、Book3 = File Name
Sheet1 = 頁名稱
$A$4、$A$3 = Cell 位置


收錄日期: 2021-04-27 13:59:56
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20080121000051KK00972

檢視 Wayback Machine 備份