Best way to make solver do multiple analysis on a worksheet is to use
coding.

I use a basic loop function to reset solver each time it runs and then reset
all the data by code. I have it doing 20 solutions on one page.

The following link will help you get started for programming the solver
http://support.microsoft.com/kb/843304/en-us



"Tushar Mehta" wrote in message
om...
Simultaneously minimize multiple cells? No, not really. After all, what
would you have Solver do if two cells had their minimum values at two
different combinations of 'adjustable cells?'

--
Regards,

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

In article ,
says...
Hi

I m using excel 2003 and I would like to know if it is possible to set
several target cells to the solver.
As we have several adjustable cells, is it possible to minimize up to 4
results for instance ?

Thanks