Hi,
I am very new to macro and am trying to create a loop for solver, but I can't seem to get it right
basically I have 2 separate sets of solver
1st: minimize col L by changing col M to S & also make sure sum of col M to S = 1
each set of solver only pertains to 1 row e.g. minimize cell L2 by changing M2:S2 & Sum(M2:S2)=1
2nd: minimize col V by changing col W to AC
each set of solver only pertains to 1 row e.g. minimize cell V2 by changing W2:AC2
I would appreciate the help given by anyone thanks
Bookmarks