View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ozenibo@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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