Hi GregDP
Instead of doing the process 3 times in different sheets, I would like to do it in one step
Not excatly what you asked for but since your setup in every sheet is the same except for the cost part (New1 to New3) you could set up a macro to loop through the sheets and running solver on each sheet.
To get this to work you must also set a reference to Solver in "Visual Basic". Open the "Visual Basic" window, select "Tools", then "References" and "tick" box marked "Solver"
To run Solver 3times on the same sheet perhaps someting like this. A bit more clumsy if I may say so.
Will change the "cost" row and copy values from the solver run to A12, A24 and A36. As before you must have set a reference to solver if you use a macro.
Alf
Bookmarks