Solver in Excel 2002

  • Thread starter Thread starter Damon Williams
  • Start date Start date
D

Damon Williams

Solver is setup to change one target cell by manipulating
a group of adjustable cells. I need to simultaneously
change 11 target cells while manipluating the same group
of adjustable cells. Please tell me this is possible, and
how or else the last 6 hours of my life were a waste.
Thank you.
 
Are all the target cells the same value in each case as the one you are
adjusting with Solver. If so then simply tie the other 10 to the 11th by using
=A1 for each cell, assuming your 11th cell was in A1. Then run Solver.
 
Back
Top