Updating a "solver" answer automatically

Question

Hi. Is there a way that I can make a solver answer dynamic?

For example, I change some of the parameters in a couple of cells, and the solver answer, in another cell, automatically updates. ie. I don;t have to go back into solver and copy and paste the answer. thanks!!

Answer 1

You can use a worksheet event macro, but only if you change your input cells in a specific order. (Excel needs to know when you have made the last input and are ready for a re-run)  For example if the inputs are in cells A1 thru A10, then you can use A11 s the trigger.  Once you are satisfied with the inputs, set A11; the macro can detect A11 being set to a value and run Solver automatically.