我想問excel 內面 d function

2008-09-18 12:33 am
我已經有一個EXCEL 表格A比人填…我想d同事一填完表格A…D資料可以自動0甘填入另外一個EXCEL 表格B度.(避免打2次) 請問有乜function係可以用?? Thanks very much^^
更新1:

I still don't understand how to figure it out...I am really bad at using function and stuff. I am wondering which function should I use and I don't have a clue how to type the function...like HLookup, etc.

更新2:

(There is a ordering record and every time when I enter the new data, I would like the function to automatically enter the data in the ordering form, e.g. the quantity of stock. ) Thanks very much and I really appreciate your help.

回答 (2)

2008-09-18 5:27 pm
✔ 最佳答案
for example,
FormA.xls & FormB.xls
FormA.xls worksheet also call FormA
Then you can reference the cell in FormB as following
=[FormA.xls]FormA!$A$1
2008-09-18 7:01 pm
你要求既做法牽涉到VBA既應用, 相對嚟講實在太深奧, 而且冇足夠資料, 唔詳細了解你既要求亦都好難可以做到滿意效果.

不如試試學返d基本函數, 例如vlookup, hlookup, lookup, match+index, 咁應該可以以較方便既方式做到你想要既, 例如Stock List

至於要輸入完資料, 立即update result既做法, 非要應用到VBA不可...


收錄日期: 2021-04-25 14:30:18
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20080917000051KK00969

檢視 Wayback Machine 備份