BOM requirements vba or formula

O

ozenibo

Dear All

Is it possible to calculate the quantity according to level as listed
below BOM to purchase order list.

Item no referance part no description UM QTY Level
21 T1 Kod1 Telefon adet 1 0
22 L1 Kod2 Alt kutu adet 2 1
23 L3 Kod3 Civata adet 2 2
24 T2 Kod4 Somun adet 3 2
25 L5 Kod5 alt kapak adet 1 2
26 L6 Kod6 Üst kapak adet 1 2
27 L7 Kod7 kablo m 0,25 3
28 L8 Kod8 Ahize adet 3 1
29 L9 Kod9 Plastik gövde adet 2
30 L10 Kod10 Helezon kablo adet 3
31 L11 Kod7 kablo m 0,5 2
32 L12 Kod12 Mikrofon adet 1 2

Purchase order list format.This list has unique and total records.

part no description UM QTY
Kod1 Telefon adet 1
Kod2 Alt kutu adet 2
Kod3 Civata adet 4
Kod4 Somun adet 6
Kod5 alt kapak adet 2
Kod6 Üst kapak adet 2
Kod7 kablo m 2
Kod8 Ahize adet 3
Kod9 Plastik gövdeadet 3
Kod10 Helezon kabloadet 3
Kod12 Mikrofon adet 3

Does any one have any ideas. ?

Thanks
 
J

Joel

Assuming the BOM and Summary are on two different worksheets and each
worksheet has a header Row. Use Sumproduct as shown below. copy formula
down in column D. The code assumes you have columns A - C already setup on
the Purchase Order List sheet.

part no description UM QTY
Kod1 Telefon
adet =Sumproduct(--(A2=BOM!C2:C100),BOM!F2:F100,BOM!G2:G100)
Kod2 Alt kutu adet 2
Kod3 Civata adet 4
Kod4 Somun adet 6
Kod5 alt kapak adet 2
Kod6 Ãœst kapak adet 2
Kod7 kablo m 2
Kod8 Ahize adet 3
Kod9 Plastik gövde adet 3
Kod10 Helezon kablo adet 3
Kod12 Mikrofon adet 3
 
Top