goal seek multiple cells
 

is it possible to use goal seek on multiple cells?
I want to change a range of values (calculated by formula) , giving the same
fixed parameter, by changing the correspondent range of input values.
I think I managed to do it once but don't remember how...
thanks

goal seek multiple cells
 

Give up on Goal Seek and use Solver : Tools | Solver
Not there? Use Tools | Add-in to add it.
Still not there? Stick you office CD in drive; Windows Start | Control Panel
| Add/Delete Programs | Go to MS Office and use change; now install Solver
Lot of work but a very powerful tool when you get to know it.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email


"massimo" wrote in message
...
is it possible to use goal seek on multiple cells?
I want to change a range of values (calculated by formula) , giving the
same
fixed parameter, by changing the correspondent range of input values.
I think I managed to do it once but don't remember how...
thanks

goal seek multiple cells
 

"Bernard Liengme" wrote:

Give up on Goal Seek and use Solver : Tools | Solver
Not there? Use Tools | Add-in to add it.
Still not there? Stick you office CD in drive; Windows Start | Control Panel
| Add/Delete Programs | Go to MS Office and use change; now install Solver
Lot of work but a very powerful tool when you get to know it.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email


"massimo" wrote in message
...
is it possible to use goal seek on multiple cells?
I want to change a range of values (calculated by formula) , giving the
same
fixed parameter, by changing the correspondent range of input values.
I think I managed to do it once but don't remember how...
thanks