Linking data between workbooks

trustfaith

New Member
Joined
Dec 6, 2005
Messages
3
Hey Hi all I'm a univeristy student and Im currently int he rpocess of doing a project but I need some help actually I really need some major help. Situation is on excel I have created an order system with a list of products, price, product codes, quanity and a total. It works fine, but I have created another workbook called invoice. I would like the second workbookt o reflect what the input from the first work book does. Say the customer orders two PC parts I want those items qunity and price to appear on the invoice aswell, any ideas how I do this?

Thanks all for those who help!

Steven
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Watch MrExcel Video

Forum statistics

Threads
1,119,139
Messages
5,576,306
Members
412,716
Latest member
thviid
Top