Best place to get macro help?

  • Thread starter Thread starter Schultz
  • Start date Start date
S

Schultz

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.
Click to expand...

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
 
Back
Top