Linking Workbooks

[trustfaith]

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

 

[GlennUK]

And what research have you done so far?

 

[trustfaith]

I have looked through some posts and something about macros and another item about importing data but it never seemd to work for me, I tried a forumla aswell it was =sheet1A:A but I got a small amount of result for it but nothing very successful.

 

[GlennUK]

You've done duplicate posting for this subject! What's the big idea?