Fifo vba code

[hutupis]

Hi,
Firstly I apoligize for my english level. I hope I can explane myself. I am using Office 2010 Turkish.

I share a file. İt include 2 pages. Fisrt name is ALIS and second name is SATIS.
ALIS has include purchase details and SATIS has include sales details.
I need cost of goods for column K for each pages as first in fisrs out. But same stocks sales may before purchase.

FIFO.xlsx

 

[Macropod]

Cross-posted at: fifo vba code please
Please read Mr Excel's policy on Cross-Posting in rule 13: Message Board Rules

 

[hutupis]

sorry for cross-posted I did not read the rules.
I search lot of FIFO formula and vba code but they did not solve mine. I hope you can solve it.