Write a macro that calls the Solver for an optimization.
- maximise one cell
- by changing 20 cells
sum of the 20 cells =1
one max value for each modified cell
one min value for each midified cell
The example spreadsheet will be provided
This is a very small project for anyone used to Excel VBA and Excel Solver
Hello, I can prepare such Solver through VBA macro optimization. I made macros like this, to select the most profitable option with Solver in my past projects. Regards
15 freelancers are bidding on average €24 for this job
Hello, I am Excel and VBA expert. Can you provide example file? I can start now. Please note that I have 100% completion rate and 5-star feedback on 50 projects.