Solver - Finding the next best solution

You could run run solver in a loop using VBA something like

Sub LoopSolver()
Dim i As Integer

For i = 1 To 10

' Put your solver marco here

Range("T6") = Range("T6") - 0.001

Next

End Sub

To run solver using VBA you must set a refence to solver "Visual Basic" -> "Tools" -> "References" find and tick box marked "Solver"

Alf