title: Excel Orders Spread via Percentage
body: <p>I am trying to get an Excel spreadsheet take a required tonnage of a product and spread it over a number of suppliers and depots within each supplier.</p>
  <p>The required tonnage is divided by a percentage of supply and converted to loads (25t).  These loads are spread across the depots for each supplier depending on the depot stock.</p>
  <p>I am having trouble when a depot does not have enough stock to fulfil the required loads (highlighted in red).</p>
  <p>The Req Loads (column M) works perfect if there is enough stock in the depot but I need it to reduce the numbers down in column M and spread to the suppliers with the most amount of stock.</p>
  <p>Sheet</p>
  <p><a href="https://i.stack.imgur.com/fHm6X.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fHm6X.png" alt="" /></a></p>