In this video, I show you how to copy and paste results from solver to create a table of optimal results using VBA. Solver is relatively easy to automate and it can be done on either the windows or mac version of Excel. Documentation for solver functions: Enable the solver add-in: