Need to allocated stock based on delivery date

[Ravindu94]

Hi,

here attached my file which i need to allocate my stock.

in 1st table i have order number / delivery date / items and required qty . 2nd table i have mentioned closing stock . i need to allocate that closing stock to 1st table items on available qty column based on delivery date ( with delivery date priority- 1st qty for 1st delivery) any one can help me

[#2]

@Ravindu94 , it looks like duplication of https://techcommunity.microsoft.com/t5/Excel/Need-to-allocate-stock/m-p/502959#M29995

[#3]

@Sergei Baklan , here product duplicated for several delivery dates. that i need to be allocate. there are lot of items under one order number. i need to allocate it from closing stock based on delivery date