Fill Multi cells in Row if column match both worksheets

**MBCMDR** · 11-06-2009, 01:27 AM

Hello,

Two workbooks....

I have an exported Excel worksheet1 from the parts database get every Friday. We get RFQ of parts list each week from multi customers about 3000+ parts as they send in MSword, MSoutlook or MSexcel to me I make into Excel worksheet2.
I do not like to type in every part into the parts software I have my words for that software Cough Cough. The exported excel speadsheet tells the part numbers, Location, Qty, Price, ETC
I would like to take the Excel RFQ list and have it populated from the other speadsheet

SAMPLE
A1 PART number that on both spreadsheet
A2 QTY on both there request and our stock
A3 Price
A4 Location

So want a compare worksheet1 with worksheet2
A1 = A* the populate A2-A4 with worksheet1 data

MB

**MBCMDR** · 11-06-2009, 09:58 PM

No one has any type of solution? WOW

MB

**Leith Ross** · 11-06-2009, 11:26 PM

Hello MBCMDR,

You will get more interest and responses if you post your workbooks in Excel 2003 format.

**MBCMDR** · 11-06-2009, 11:38 PM

Please see the attached MSExcel 2003 sample version of the sheets.

I now know need these really bad as a customer cam to us with a parts list of 9000 parts saying this was his last year puchases and like to know what we can supply for 2010.

9000 parts wopuld take me a week to stock check each as stock software only allow 1 part per look up..

MB

**jaslake** · 11-07-2009, 05:32 PM

Hi MBCMDR
If I understood your issue, I believe the following code does what you wish.

Please Login or Register  to view this content.

The code is in the attached workbook RFQ LIST and runs from a button. The file names are hard coded and assumes both are open but that's easily changed. Let me know if you have any issues.
John