Dear Excel community
Goal
I'd like to write a VBA macro using Solver.
I've no previous experience with macros.
I am looking for a dummy guide please.
Solver input
Set Objective: 'Calc optimised'!$J$14
To: Min
By changing variable cells: 'Calc optimised'!$E$3
Subject to the constraints...