FIFO-system

[Exelhenk]

Hi, I want to make an Excek-system in a certain format. However, I have some problems making it. I hope the experts on this site can help me solve the problem. (possibly using VBA). The right material has to be found automatically and the right price must be calculated according the use of the materials. I have posted an attachment with description at http://www.worksheet.nl/forumexcel/vragen/68774-fifo.html

Who can help me?

Regards, Exelhenk

 

[Robert Mika]

Your description is in Dutch...

 

[Exelhenk]

You are completely right. My apologies. Here is a translation of all Dutch cells. I hope you are able to procees now.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
C1<o></o>
Purchase<o></o>
<o></o>
H1<o></o>
This must be automatically calculated and be adapted to the actual use each time. When the use exceeds the 250 (in this example) the use must automatically continue with the stones of 8jan2010 (FIFO-system). These stones must be found automatically while the stones are among other materials (in this case wood).

<o></o>
I1<o></o>
This must also automatically be adapted to the actual use.<o></o>
<o></o>
J9<o></o>
The system has to take €19 untill the use exceeds the 250 stones (in this example). Above the 250 the sysyem must automatically continue with the stones of 8jan2010 (FIFO-system).<o></o>
<o></o>
J10
Continuing the previous one: Here's what the intention is with regards to the actual costs. Some of the use is rated €19 and a part is rated €22. The amount must be automatically calculated and be found by ‘inkoop’. The amounts may not be taken out of "used" and/or “remaining stock”, because these are changing constantly according to the use (unless you know a way to get the right quantities in ‘use’ without that ‘use’ changes when the amounts in ‘used’ change.<o></o>

 

[Exelhenk]

The correct link: http://www.helpmij.nl/forum/showthread.php/625745-FIFO-systeem-maken