Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BOM requirements vba or formula
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
BOM requirements vba or formula
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 " 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Material Requirements Plan (MRP) and Capacity Requirements Plan (C | Excel Worksheet Functions | |||
Material Requirements Planning-MRP/Capacity Requirements Planning- | Excel Discussion (Misc queries) | |||
MVP Prerequisites/requirements | Excel Discussion (Misc queries) | |||
Excel formula that sums if meets two requirements. | Excel Worksheet Functions | |||
Name Range with three requirements | Excel Worksheet Functions |