Hello there,
I am using solver to maximize the value of a certain cell. I have number of constraints and everything is working fine. My problem is, that I have over 700 lines of data, and that would mean I would have to manually plug my data into solver 700 times. Is there any way to automate it? Simple example so it is perhaps easier to understand.
Maximize value of $A$1,
by changing variable cells $B$1:$F$1,
subject to constraints:
$G$1:$K$1 <=1
$L$1 = 1
$M$1:$R$1 <= 0,3
As you can see, every variable is present in the same row, and I have over 700 rows of data. The only thing that should change in the solver is the row number.
Thanks for any help, or advice in the right direction.
Bookmarks