I have an excel worksheet in which the value of one cell is determined by
the values that are imputed into two other cells. I want a macro to run all
possible combinations of numbers in the two cells and give me the
combinations that result in the highest values in the third cell.

Does anyone know the best place online to find out how to do this or have
any general advice? I am looking, and most everything talks about the macro
recorder, which I do not believe is itself going to do what I want.

Thanks for any help.

Schultz wrote...
>I have an excel worksheet in which the value of one cell is determined by
> the values that are imputed into two other cells. I want a macro to run
> all
> possible combinations of numbers in the two cells and give me the
> combinations that result in the highest values in the third cell.
>
> Does anyone know the best place online to find out how to do this or have
> any general advice? I am looking, and most everything talks about the
> macro
> recorder, which I do not believe is itself going to do what I want.
>
> Thanks for any help.
>

Schultz,

Try Tools | Solver.

You probably don't need to run a macro.

Have a look at XL's help on Solver.

Hope this helps.

Regards,
Kevin