Help to make solver recalculate upon parameter change

I'm using solver to optimise a product mix, this is working fine.

I would appreciate some help on how to get solver to recalculate automatically upon a change of any of the parameters.

I'm assuming this would need to be done via vba.

Sample file attached

You could also set the min and max constraint for production using two lines i.e.

Please Login or Register  to view this content.

Alf

Thanks for the reply's

Kaper, the vba you have posted fails when I change a parameter in the range B4:G5.

Alf, yes I realised I could do that after reading your reply, thanks

The way the model is set up you have negative amount of "Amt left" on Material 2, 5 and 7 this causes Solver to go infeasible ( as Kaper suggested) so there will be no change of values i.e. a Solver run untill you fixed that.

Looking at the formula in K7 to K13 should it not include the G column? I.e. "=SUMPRODUCT(B7:G7;$B$15:$G$15)" for K7 for instance.

Alf

Thank you both for your help, all is working well now.

Thanks for feedback and rep.

Alf