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