Linking 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

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

trustfaith

New Member
Joined
Dec 6, 2005
Messages
3
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

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
You've done duplicate posting for this subject! What's the big idea?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,228
Messages
5,571,000
Members
412,353
Latest member
SofiaV
Top