goal seek multiple cells

[massimo]

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

 

[Bernard Liengme]

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

 

[massimo]

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