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.