Picking select data out of a larger data sheet

[wfjohnrage]

I have an excel sheet with specific part numbers in it. I also have a seperate workbook in the same file with every part number in the plant.

I haven't used excel in detail that much in recent years, but I am pretty sure you can do this.

The main part number sheet contains part numbers for the entire plant and quantities of these parts in specific locations.

The second sheet has only specified part numbers


here is how it looks:

Part # | Loc A | Loc B | Loc C | Loc D | Loc E|
11111 | 1000 | 2000 | 1400 | 2300 | 1600 |
11112 | 1500 | 1000 | 2200 | 4500 | 6000 |
11113 | 6000 | 2500 | 1400 | 6000 | 7000 |

Basically I have a separate sheet (in the same file) of part numbers and locations and I need to pick out the specific part numbers and also have it list the quantities similar to how the main sheet is setup.

Can some one get me started.

Thanks

 

[wfjohnrage]

Seems simple, anyone?????