Using multiple instances of solver

[Tibbs]

I'm trying to find a solution to an optimisation problem, and Solver appeasrs to be the tool to use. However, I have not used it before, and was hoping for some help in application.

I have a very simple set of constraints, which I've detailed below, but I need it to solve 54 different combinations of data on one sheet! All the data would match up if I could copy & paste the solver into different places...

I also need to do it so the users can update the information and rerun the solvers on a weekly basis.

Would this be really difficult?

Regards,

Chris

---

The Constraints
Set Target Cell: $K$1 = 26
By changing Cells: $H$2:$H$7
Constraints:
$G$2:$G$7<=$J$2
$H$2:$H$7=integer

[MrShorty]

You'll need to create a VBA Sub procedure that will loop through the various optimizations. Probably easiest to start by recording a macro that will do the first problem. Then nest that code inside of a loop that will go through each problem one at a time. It would then be easy enough to create a button, or a toolbar button, or a menu item that will call the macro when the user wants to update.

[Tibbs]

That's what I thought - thanks Mr. Shorty!

Ho hum, more VBA learning to do...

Tibbs