Several target cells in the solver

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

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 <[email protected]>,
[email protected] 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
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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 <[email protected]>,
> [email protected] 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
>>

Yes, it is possible to use Solver with VBA. But, I am not sure how that
helps the OP.

--
Regards,

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

In article <[email protected]>, [email protected]
says...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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 <[email protected]>,
> > [email protected] 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
> >>
>
>
>