To get a price from the price list while making a purchase order

Closed
Report
Posts
4
Registration date
Wednesday May 28, 2014
Status
Member
Last seen
May 29, 2014
-
Hi,I would like to know how to reate a macro code I have two files one named Price list and other Purchase Order. Actually I wanted like this ,the price should come automatically from the price list when entered an Item in purchase order without opening the price list workbook.

eg; In the price List

Name of the item Price
Soap 6.00
Tooth brush 10.00

In the Purchase order
Name of the item Price
Soap ?

So while typing the item in the purchase order the price should come automatically without opening the price list.
Related: