Match and insert corresponding data across spreadsheets

[patrickt]

Hello, I have a task that would take me hours to complete and I'm sure there's got to be a way to do it in Excel 2007. I need to get part numbers from one master cross reference spreadsheet to individual spreadsheets. The master cross reference spreadsheet has our company 7-digit number AND the manufacturer part number, while the individual spreadsheets only have the manufacturer part number. I need to have the individual spreadsheets match manufacturer part numbers and then insert our company's 7-digit number line-by-line.

Master spreadsheet (snippet):

7-digit PN MFG PN
2206422 A04-04L
2209624 A04-04S
2203436 A04-054
2208761 A04-06A
2208897 A04-06C
2208942 A04-06D
2209292 A04-06E
2209108 A04-06F
2209627 A04-06S
2208764 A04-08A
2208900 A04-08C

Individual spreadsheets (snippet):

7-digit PN MFG PN

? A04-604
? A04-605
? A04-606
? A06-604
? A06-605
? A06-606
? A06-608
? A06-610
? A08-606
? A08-608
? A08-610

Hopefully this makes some sense.

Thanks!