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.

  • gentle_20052006

    Changed the title of the thread from “Stock report -consumption data-VBA to distribute value based on cell value” to “VBA to distribute value based on cell value”.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!