Note: For illustration purposes, Columns E and F (Wkst 1) would normally be on a separate worksheet and columns H and I (Wkst 2) would be too.
I'm trying to design a macro that will look at a result (M or B) in column C, and if B, look for the Component Item # in Column A and using that, find all of the Purchase Orders in Wkst 1 associated with the Item Number. Ideally, I would like for the results to show in one cell - see cell B3 as an example. If Column C contained an M, it would search Wkst 2 and return the Manufacturing Order numbers associated with the lookup value - see cell B4 as an example. Thanks!
I'm trying to design a macro that will look at a result (M or B) in column C, and if B, look for the Component Item # in Column A and using that, find all of the Purchase Orders in Wkst 1 associated with the Item Number. Ideally, I would like for the results to show in one cell - see cell B3 as an example. If Column C contained an M, it would search Wkst 2 and return the Manufacturing Order numbers associated with the lookup value - see cell B4 as an example. Thanks!
Shortage_Report_MAS200_Version(main) - Sanitized.xls | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Component | PO/WO | Make/ | Item | Item | ||||||
2 | Item# | Number | Buy | PurchaseOrders | Number | ManufacturingOrder | Number | ||||
3 | KBR11450 | 807060807061807062807063 | M | 807060 | KBR11450 | 807060 | KBR11450 | ||||
4 | 90005000 | 808080808081808082 | B | 808080 | 90005000 | 808080 | 90005000 | ||||
5 | KBR11450 | M | 807061 | KBR11450 | 807061 | KBR11450 | |||||
6 | 90005000 | B | 807062 | KBR11450 | 807062 | KBR11450 | |||||
7 | KBR11450 | M | 808080 | 90005000 | 808081 | 90005000 | |||||
8 | KBR11450 | M | 808080 | 90005000 | 808082 | 90005000 | |||||
9 | KBR11450 | M | 807063 | KBR11450 | 807063 | KBR11450 | |||||
WO Detail |