ExcelBanter - linking data from one workbook into another

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - linking data from one workbook into another (https://www.excelbanter.com/excel-worksheet-functions/47465-linking-data-one-workbook-into-another.html)

Jazzers

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 :confused:

--
Jazzers
------------------------------------------------------------------------
Jazzers's Profile: http://www.excelforum.com/member.php...o&userid=27600
View this thread: http://www.excelforum.com/showthread...hreadid=471214

Anne Troy

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 :confused:

--
Jazzers
------------------------------------------------------------------------
Jazzers's Profile:
http://www.excelforum.com/member.php...o&userid=27600
View this thread: http://www.excelforum.com/showthread...hreadid=471214

Jazzers

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

Anne Troy

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

All times are GMT +1. The time now is 08:41 AM.