MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Cross Reference Inventory Pricing

Posted by Mike Hanlon on January 17, 2002 8:49 AM

Workbook1 has a list of 40,000 parts, listed by
part number and defines price of each part.
Workbook2 has a list of 500 parts listed by part number
and needs to be priced. Is it possible to use the
list in WB2 to search WB1 by part number and if numbers
match then copy price from that item to the pricing
cell in WB2

Posted by Jacob on January 17, 2002 9:06 AM

Application.DisplayAlerts = False
Application.DisplayAlerts = True