COMPLICATED MAKRO - NEED PRO !!!!!!!

[Dmrs92]

Hello,

I'm trying to find solution with Excel - but i'm toatally do not know vba, so I need your help guys.

PRO8LEM:
I need program that will sum amount of requirements for products.

PRODUCT A - need 1 kg of element 1
PRODUCT B - need 1 kg of element 2
PRODUCT C - need 2 kg of element 1
PRODUCT D - need 1 kg of element 1

Those elements have unique codes.



Now I have more products and more elements sometimes element is used for 20-30 or more products and now the problem occur.

I put order for those products 1,2,3 ............


I need makro/vba which will sum amount of those elements based on my order. 1.PRODUCT A - find element - amount / 2. product B - find element - amount - keep summing untill next product will need other element then put result and the switch to next cell and start to count for next products. Sometimes product than need one element occur few times in this order.


I have list of peroducts, elements and amounts.... - it is hard to do with IF or other formulas - a lot of data and really do not know how make it.

Thank you in advance,

 

[yky]

Could you upload an example sheet to the net so people can download and work on it?