Hi,

Looking for some help with a growing task. I have 35 market areas which need to receive allocation of stock. This stock can vary in specification and it's important that they each receive an even split. At the moment I'm using tables and formulas to divvy the stock up but the number of variations within the stock is growing making it a very manual task due to rounding errors. I've attached a sample of data for 10 market areas and 93 stock items, of which there are 18 variations. What I would like to return is a Market Area against each order number with an even distribution of models for each area. Any thoughts on how this could be achieved with code? I've used a small sample to illustrate but the actual data would be 35 market areas and up to 3,000 stock items with 100+ possible variations.

Any help would be greatly appreciated. Many thanks in advance.

Book1.xlsx