title: Excel Slider Control: How could I limit the sum of all sliders to, say, 100?
body: <p>See image for clarity.</p>
  
  <p><img src="https://i.stack.imgur.com/wCNDZ.jpg" alt="Slider"></p>
  
  <p>I have 5 variables (A, B, C, D and E), each of which can range from 0-100. I need the <em>sum</em> of all these variables to be 100 at all times, not more, not less. However, the way it is set up currently, if I change variable A from 21 to, say, 51, the total becomes 130.</p>
  
  <p>How could I set this up such that if I change one variable, the others could automatically compensate for that increase or decrease, such that the total is <em>always</em> 100?</p>