I have what I think is a simple problem.
In cell B2 I have a number. I allow this number to change to maximize the solution in AC3. I then want to paste this optimized value from B2 into C3.
Then I want to rerun the program. I want B2 to change again, but this time I want to maximize the solution in AC3 and paste the solution into C3. How can I do this for all the way up to AC32 and pasting the solution from each optimization into its correspond cell in column 3?
If I run solver and record the macro, I get this:
So I want this to loop from Ac3 to Ac32
Bookmarks