title: Get excel to continually 'goal seek'
body: <p>I have a spreadsheet with numerous inputs, but one output (a price).</p>
  
  <p>I want to get excel to automatically update one of the inputs (call it input 1) in order to keep the price constant whilst I adjust the other inputs.</p>
  
  <p>I know 'goal seek' can do this, but I don't want to have to rerun the goal seek everytime I adjust another input. I particularly do not want to have to do this because I want to use scenario analysis to adjust the other inputs individually, and see how input 1 would need to change in order to keep the output (price) constant.</p>
  
  <p>Someone asked a similar question here: <a href="https://stackoverflow.com/questions/12698293/need-excel-goal-seek-logic">Need Excel Goal Seek Logic</a></p>
  
  <p>However there is no useful answer given to that post.</p>
  
  <p>Would be most appreciative if anyone could help out please.</p>
  
  <p>Thanks,</p>
  
  <p>Timothy</p>