VBA to distribute value based on cell value

Hi all,

I have two input area of stock report and consumption running into 1000 rows. I want to update stock report with consumption qty as per the Batch No. Since stock report contain multiple entries of same batch no it is difficult to manage with formulas. It is possible with pivot table but the stock report is as per warehouse location based. So I would like to get help from forum experts.

Thanks in advance.

Pls someone help me to get rid of the above problem. It is happening routine so i need suitable formula or VBA code to resolve it.