Hi, I'm relatively new to Excel and haven't done any VBA coding of any kind. Essentially, what I'm trying to do is automate Solver so that when cell A1 or A2 is changed, my worksheet will automatically run Solver (and keep the solver solution). So when I go into solver, my parameters are as follows

Set Objective: $W$16
To: Min
By Changing Variable Cells: $W$7
Subject to the constraints: $W$13 = $H$7

Any assistance would be appreciated.

Thanks