Apr 30 2019 04:40 AM
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
Apr 30 2019 01:13 PM
@Ravindu94 , it looks like duplication of https://techcommunity.microsoft.com/t5/Excel/Need-to-allocate-stock/m-p/502959#M29995
May 01 2019 08:15 PM