linking data from one workbook into another

J

Jazzers

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

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
 
Top