FIFO Inventory

Not exactly. I want to use the "First In First Out" or FIFO philosophy here, I want to use all of the eggs from the first PO# before going into the stock of the second PO#. But thank you for the help.

Thanks Xx7, it looks like the Pacific Northwest is on point today. That works very well for the conditional formatting, but I am still having trouble with the formulae for the third table. Any ideas?

Sorry about that Marvin. I uploaded two different books both called FIFO The "Un"attached file is I completed the math manually. Sorry about that.

On another note, Is there a way to use the =MOD() function to do subtraction instead of division?

I put it in the macro instead of a formula.. this should do it.

Please Login or Register  to view this content.

Originally Posted by Xx7

I put it in the macro instead of a formula.. this should do it.

Thanks Xx7, that does the trick. I greatly appreciate it.

Originally Posted by MarvinP

Hi Jake or Bill,

It is great to ask a question and get an answer that doesn't relate (anywhere close) to what was asked.

My answer is certainly not!! The Mid Function can't be used in these kinds of problems.
It is very bad also to put all your old eggs in the same basket.
I hope this makes perfect sense based on your question above.

Also Please see the (non) attached file for a perfect explanation of what I'm getting at.

I'm sorry that my message was confusingly written, I work on a production floor with many distractions away from my desk that cause me to lose my train of thought and garble my messages sometimes on forums.

But I was referring to at the beginning and end of my first post there are links to the sheet that I finished manually editing the data. The file at the bottom of my first post is inside of a box that says "Attached Files". That is the file I assume you were referring to. Also I said =MOD() not =MID().

Hello Guys,

I have a requirement for the FIFO Inventory system.

I update the Purchase in one tab and sale in other tab and in the sales tab i want to see me purchase price based on the FIFO method.

Can any one Help me.