title: Proportional distribution
body: <p>Can you please help me to understand how to distribute the amount using coefficient and quantity for every part using some formula or VBA macro?
  The table is really large to do it manually. 
  <a href="https://1drv.ms/x/s!AoMHe_jxCdkDj_9TutQTpp2bjIVEGg" rel="nofollow">Please find excel table extract sample.</a> 
  "Amount to be distributed" column corresponds to the "Key" and each cell is duplicated, so e.g. cells E2-E4 should not be summarized. The first line of each duplication occurence in the "Amount to be distributed" column should be distributed using "Coefficient" and "Quantity".<br>
  E.g. I want 733134.89/(110+60+90) then distribute the given proportionally to D2, D3, D4</p>
  
  <p>Many thanks in advance.</p>