Solver in Excel 2002

[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.

 

[Ken Wright]

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.

 

[Tushar Mehta]

Also check the response in .misc

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions