Hi James,

I understand your frustration with having to manually run Solver on all the different scenarios every time you adjust your rates. The good news is that there is a way to make Solver automated using VBA (Visual Basic for Applications).

Here are the steps to create a macro that will run Solver automatically:

1. Open the workbook that contains your Solver scenarios.
2. Press Alt + F11 to open the Visual Basic Editor.
3. In the Project Explorer window, double-click on the sheet that contains your Solver scenarios.
4. In the code window, paste the following code:
   
   
   Formula:

   Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("A1")) Is Nothing Then
        SolverOk SetCell:="$B$1", MaxMinVal:=3, ValueOf:=0, ByChange:="$A$1", _
            Engine:=1, EngineDesc:="GRG Nonlinear"
        SolverSolve UserFinish:=True
    End If
End Sub 

5. In the code, replace "A1" with the cell reference of the cell that contains your rate.
6. Replace "B1" with the cell reference of the cell that contains your repayment figure.
7. Save the workbook and close the Visual Basic Editor.

Now, every time you change the rate in the designated cell, the macro will automatically run Solver and update the repayment figure in the designated cell.