Joined: 20 Jul 2003
|Posted: Tue Aug 05, 2003 4:38 pm Post subject: Using goal seek with scenarios as part of input.
|I wonder if it is possible to "save" a goal seek value?
Let me explain. In 1 worksheet I have several scenarios, each scenario has several numbers listed down the column (product and chemical analysis of that product)
Column A - Headings, column B - variables in scenarios. Cell F5 - application rate. Column C =result F5*B3etc.
To begin I just had the scenario items multiplied by an application rate,(F5) giving me the total amount of chemical applied.(Column C) Then I began to play around with goal seek, thinking that if I needed, say 10 of a certain element, what would the application rate be. Great, it works very well, however, when I select another scenario I have to open the goal seek dialog and enter the details again.
Is there a way I can do this without having to re-open the goal seek dialog?
Thanks in advance!