How can I distribute the balance data to the following date randomly.

HELP: how can I distribute the balance to the following date randmonly.
I would like to distribute values in cells depending on the input value.
And basically i've been entering the data manualy.
and i would want it to happen that when i enter the following balance, it will automatically distribute itself to the following shipment date
it is randomly distributed because this is just an assumption on how many of the balance can be shipped on the set dates.
distribution of values.xlsx

Thanks for producing a sample sheet and trying to explain the issue. Unfortunately I really can't understand what you are trying to do. How about you take us through an example.