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
"(E-Mail Removed)" wrote:
> 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
>
>
>
>
|
Similar Threads
