| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
linking data from one workbook into another
I have 2 workbooks, one contains inventory data (codes, item descriptions, prices) and the other an invoice where I want to place drop down Code bar in rows. I would like to select an item code in the invoice and the description and price automatically come up, derived from the source workbook. And how do I get to copy & paste the formula so it changes with each row number as I progress down the form. Thanks!!! Jasmine  -- Jazzers ------------------------------------------------------------------------ Jazzers's Profile: http://www.excelforum.com/member.php...o&userid=27600 View this thread: http://www.excelforum.com/showthread...hreadid=471214 |
|
#2
|
|||
|
|||
|
Jasmine: Try this:
http://www.officearticles.com/tutori...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "Jazzers" wrote in message ... I have 2 workbooks, one contains inventory data (codes, item descriptions, prices) and the other an invoice where I want to place drop down Code bar in rows. I would like to select an item code in the invoice and the description and price automatically come up, derived from the source workbook. And how do I get to copy & paste the formula so it changes with each row number as I progress down the form. Thanks!!! Jasmine -- Jazzers ------------------------------------------------------------------------ Jazzers's Profile: http://www.excelforum.com/member.php...o&userid=27600 View this thread: http://www.excelforum.com/showthread...hreadid=471214 |
|
#3
|
|||
|
|||
|
Hi Anne, This is awesome. Thank you very much for the link. I'll get on it and let you know how it goes. Tks again, Jas -- Jazzers ------------------------------------------------------------------------ Jazzers's Profile: http://www.excelforum.com/member.php...o&userid=27600 View this thread: http://www.excelforum.com/showthread...hreadid=471214 |
|
#4
|
|||
|
|||
|
You're welcome!
************ Anne Troy www.OfficeArticles.com "Jazzers" wrote in message ... Hi Anne, This is awesome. Thank you very much for the link. I'll get on it and let you know how it goes. Tks again, Jas -- Jazzers ------------------------------------------------------------------------ Jazzers's Profile: http://www.excelforum.com/member.php...o&userid=27600 View this thread: http://www.excelforum.com/showthread...hreadid=471214 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing unopened worksheet into an open Workbook | Excel Discussion (Misc queries) | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Excel: Use a name with external workbook reference for data valida | Excel Worksheet Functions | |||
| linking workbook data | Excel Worksheet Functions | |||
| Extract specific data into its own workbook via macro? | Excel Discussion (Misc queries) | |||
Hybrid Mode
