Automate Solver in Excel on Windows or Mac with VBA

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: docs.microsoft...
Enable the solver add-in: support.micros...

[@RingoSimpkinsUK]

That was the most straighforward solver VBA explanation I have seen .. thanks .. I now fully understand, the problem set up bit is exactly what I needed to know!

[@mitchneal5981]

I didn't click solver in the references in VBA, couldn't get this to work. Thank you so much for the great video!

[@srinivasanbalan2469]

Excellent Video. I must recommend this to all Excel users

[@user-yq4ts4hp1x]

Great demonstration! Thanks!!

[@sangeetaverma8349]

The video is very useful. I have recorded a macro for optimization using excel solver, but the code is not running properly and giving the expected result. I need your help. How can I contact you?

[@smithjohn7815]

Could you share the Example xlsm file ?

[@mitchneal5981]

I didn't click solver in the references in VBA, couldn't get this to work. Thank you so much for the great video!

[@ondrakolarik888]

same here!