You've attached a basic list of stock. I don't know what VBA you want. We can't write VBA without knowing what we are working with and what you expect it to do.
Using VBA I want to populate columns Shippable and Stock Leftover
Posts by rahulmamtora
-
-
No idea what you mean. How can we provide VBA for this when we have no idea where the the data is stored?
Why do you think that you need VBA for this? My example doesn't.
Please help me understand which aspect of my request you did not understand and I will try to explain much clearly.
-
You need some kind of database to record stock movements in and out. Then a master sheet that shows available stocks.
Your example actually only has the master sheet. This is an example of what I mean
Thanks for your reply Roy, let me clarify that you can consider stock-at-hand/available stock is looked up from a different report. So here I just need help in vba that handles Shippable and Stock leftover.
-
Disclaimer: I admit this is cross-posting, as I had first posted this on Excelforms and I did not get the solution that I am looking for.
Hi All,
Please refer to the below snapshot. I want your help to be able to allocate available stock as shippable and alongside it running Stock leftover until it gets exhausted.
So in here I have some dummy order numbers and 3 material in stock and based on the ordered quantity I want to allocate available stock until it becomes zero.
I tried using nested-if, but since my actual data is too big and some of the cases where for some of the materials the rows are more than 30, I found it difficult to arrive at a formula that suffices my above requirement of allocating shippable and showing stock leftover, if any.
Thanks for your help in advance.