Multiple Solver uses automatically

[Guest]

I'd like to use Solver to solve for many cells by changing the cell next to
each target cell. Is this possible or do I have to use solver for each cell
individually?

 

[Tushar Mehta]

I'd like to use Solver to solve for many cells by changing the cell next to
each target cell. Is this possible or do I have to use solver for each cell
individually?

If it is part of the same problem, you can specify any number of cells in
the "by changing cells" field.

If it is part of a separate problem, you would have to set up and solve each
problem individually. It could be automated through VBA code but each
problem would still have to be solved individually.

--
Regards,

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