first in first out

[eing]

Hello, maybe my last thread was very complicated to do..
http://www.excelforum.com/excel-form...ml#post3536034

So, I decided to ask another question that may be more simple to solve my problem..
This may offer different result from my last thread..
please take a look at my workbook:
FIFO.xlsx
I'll be waiting for the solution..
Thank you very much..

[hemesh]

Can you explain it a bit further ! What actually you want to do ?

[eing]

@Hemesh:
Thank you for your reply..
Have you downloaded the sample workbook..?
You can unhide the U column to show you what I'm trying to do further..

In this workbook, you can see that I'm doing the calculation manually..
So, what I'm asking is, is there any solution to do this kind of calculation automatically..?

[eing]

I'm hoping that, at least I could fill the yellow cells with a better formula..
that might be very helping..

[eing]

I'm sorry, is it very difficult to be solved..?
Or is there anything that still unclear enough..?
If it so, I'd be glad to explain it then..

[patel45]

Maybe it's not difficult to solve, but you have to explain better in another way

[eing]

I really thank you for the reply..

But I'm so sorry, I will never know which part of my explaination that not clear enough if there's no people asking for it..
Just let me know what you need..
I'd be happy to tell everything that needed..
Thank you..