更新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.