Allocating Stock-In-Hand To Ship-out

small example attached - master table only saves the balance movements - one line per item.
transaction movements are individually recorded - use forms - do not enter data directly into sheet - there are no on-sheet formula involved.
if however you want an on-sheet formula solution the first thing you must do is - GET RID OF MERGED CELLS.
torachan.

Thanks Torachan for your reply. Actually, I have huge data from my ERP tool that has various fields, and out of that, I have just shared some key fields that relate to what solution I am looking for.

And yes, we can get rid of the merged cells (I have updated the attached file, removing the merged cells), as that was just for illustration purposes to show that we have 100, 30, and 80 materials in stock, rather than repeating on each of the rows.

I would request you and others to please help me with my solution in any which way possible.

Thanks!

Bumping this thread for urgent attention. Thanks!

Originally Posted by rorya

Cross-post: https://www.ozgrid.com/forum/index.p...nd-to-ship-out

Thanks for pointing out this. Yes, I admit I have also raised my question on another forum, as I waited for 24hrs for a solution on ExcelForums. And now it's become urgent for me to get the solution, hence with "disclaimer" I have posted on another forum. From whichever source I get the exact solution, I will close rest of the threads as solved by giving link to the solution.

We do not expect anyone to 'bump' a thread within 24 hours (in your case less than 18 hours)
It may be urgent to you - it is certainly not urgent to me.
The help we give is voluntary and free of charge, therefore it is given on our term and on our timescale.
The forum members are from across the globe, they may have been at work or nighttime and asleep, and have not possibly seen your post yet.
The message is direct and simple, first read the forum rules and abide by them, secondly do not expect us to jump through hoops just to satisfy you.
torachan.

Originally Posted by torachan

We do not expect anyone to 'bump' a thread within 24 hours (in your case less than 18 hours)
It may be urgent to you - it is certainly not urgent to me.
The help we give is voluntary and free of charge, therefore it is given on our term and on our timescale.
The forum members are from across the globe, they may have been at work or nighttime and asleep, and have not possibly seen your post yet.
The message is direct and simple, first read the forum rules and abide by them, secondly do not expect us to jump through hoops just to satisfy you.
torachan.

I respect all your voluntry help which is a noble cause, respect. I agree to what you have said and I put all the efforts to adhere to it. Its just that this time around I have bit of urgency, hence I had to take this step. I hope you understand. Thanks!

Originally Posted by rorya

But you still haven't posted all your cross-post links...

Since you asked for it... here are the reposts

https://www.ozgrid.com/forum/index.p...t/#post1250524
https://chandoo.org/forum/threads/al...hip-out.46493/

I hope this helps.