Re: Excel: Solver



Turn on the macro recorder (Tools | Macro > Record new macro...) and
solve one problem by hand. Turn off the recorder and switch to the VBE
(ALT+F11). Share the code in the newsgroup (as text in the message not
as an attachment) and also indicate how the other scenarios are laid out
in the work***. Someone should be able to give you a generalized
solution.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article <uztdqXdSFHA.1236@xxxxxxxxxxxxxxxxxxxx>,
leonardo_checchi@xxxxxxxxxx says...
> Hi,
>
>
>
> I should apply the solver function a lot of times and I'd need to know if
> exist a function that make me able, once I've set the solver up, to obtain
> the estimated coefficient of the regression (the output
>
> of the solver) for each month of a my temporal series without change every
> time the cells.
>
>
>
> I hope you have understand what I mean, cause I'm not English, and someone
> can give me help.
>
>
>
> Thanks. Bye
>
>
>
.