Multiple Solver uses automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Box815 said:
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?
Click to expand...
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
 
Back
Top