Macro to copy specific data from one WB to specific cells in another WB based on specific

Hello All, I'm looking for help in writing a Macro to copy specific data from one WB to specific cells in another WB based on specific criteria. I have 2 workbooks, one is Bill Of Materials, the other is a Vendor List. What I'm trying to accomplish is using the Vendor name I've entered in the BOM workbook to copy the "Phone" and "Contact" information from the Vendor List workbook to the appropriate Cells and Column in the BOM workbook.

Any help is greatly appreciated. Thanks in advance

br/dave r

John, I want to thank you for your reply. The only changes I had to make were the references to the File & Sheet names used in the actual documents, other than that it worked exactly as I wanted and your efforts are much appreciated.

Thanks again,
dave