distribute stock quantity over different lines so sum ends up with stock quantity

**is2_egypt** · 04-11-2019, 08:16 AM

Hi experts

I have 9 products with X prices & Y quantity, and i need you to distribute those products around 300 invoices/rows To my diffrent customers (they can be repeated) Thé final quantity and the final prices on All the invoices must match with the initial stock.

filling the customer column , products and quantity is random on condition that stock is not exceeding the initial stock.

wish experts here can help me

BR
Ibrahim

**Kaper** · 04-11-2019, 12:17 PM

Dear Ibrahim,

Such macro shall do the job for you:

Please Login or Register  to view this content.

I think it meets all requirements. Of course you can add more data to Data Base sheet.
Honestly, it probably should go to https://www.excelforum.com/commercial-services/
but as I treated it as a kind of challenge, I solved it on the open forum.