How to create function trade alloction ?

[esugiawan]

I have 1 customer with trade more than 1 item , like this





at the end of day, customer, want to split that transaction into several customer, with same avg price ,only difference qty , like this


my question is , how to create function in vba ms.access to get result like this ( new trade detail )


that new trade detail i got manually using solver ms.excel

thx

[ranman256]

youd make a 'temp' table to hold the new values.
in a form, you could ask the user to select Trade, how many splits on it, then produce the grid of results in the temp table.

then after validating the volume and amts, post the temp table to the actual working table.

[esugiawan]

youd make a 'temp' table to hold the new values.
in a form, you could ask the user to select Trade, how many splits on it, then produce the grid of results in the temp table.

then after validating the volume and amts, post the temp table to the actual working table.

can you help me with example , how to produce automatic new value trade allocation, cos i dont know the algorithm , if i have data like above ? right now i do it with manual (solver ms.excel)