Excel VBA macro calling Solver for simple optimization

Write a macro that calls the Solver for an optimization.

Solver params:

- maximise one cell

- by changing 20 cells

- constraints

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

Keahlian: Excel, Visual Basic

Lihat lebih lanjut: vba macro excel googlefinance, vba macro excel freelancer, vba import excel spreadsheet accesss, record list vba macro excel, software write mq4, software write chip epson, useful software write book, print button macro excel spreadsheet, access vba data excel spreadsheet, software write web specs, vba work excel spreadsheet, free vba macro excel stocks, free software write user guide, pre written vba macro excel, software write edid, free software write company profile, access vba manipulate excel spreadsheet, software write websites idea, access vba import excel spreadsheet, software write book images, vba macro excel enable paste protected sheet, software write books, vba macro excel display contents, software write protection, free software write book

Tentang Pemberi kerja:
( 11 ulasan ) Paris, France

ID Proyek: #12201032

Diberikan kepada:


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

€17 EUR dalam 2 hari
(11 Ulasan)

15 freelancer menawar dengan rata-rata €24 untuk pekerjaan ini


Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach y Lebih banyak

€30 EUR dalam 3 hari
(100 Ulasan)

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.

€29 EUR dalam 1 hari
(54 Ulasan)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind o Lebih banyak

€30 EUR dalam 1 hari
(66 Ulasan)

Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporti Lebih banyak

€30 EUR dalam 1 hari
(30 Ulasan)

A proposal has not yet been provided

€10 EUR dalam 1 hari
(17 Ulasan)

Hi Mr. Employer I have lot of experience in excel spreadsheet and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Excel . Google sprea Lebih banyak

€25 EUR dalam 1 hari
(13 Ulasan)

I have the required expertise for developing your project. Check developed projects and reviews of my portafolio.

€14 EUR dalam 3 hari
(6 Ulasan)

Hi , I am interested by your offer: Excel VBA code. I will be happy to do this job even though I'm new in the field of freelance. Let me know more details of this work. I will start working immediately :) B Lebih banyak

€15 EUR dalam 0 hari
(9 Ulasan)

Hi, Please provide the sample file and I will do it for you. Let me know if you have question. Thanks Rajeev

€30 EUR dalam 2 hari
(5 Ulasan)

- good in excel vba, formulas, functions, and excel solver optimization solutioning - ensure data accuracy and deliver on time

€14 EUR dalam 1 hari
(3 Ulasan)

Hi this Ravi. I am working in testing from last 5 years. I use the excel macros every day to day work. till now I created different types excel VBA macros. I would like work with you if you are interested. please let Lebih banyak

€12 EUR dalam 1 hari
(0 Ulasan)

Hello, I am able to do the work on your project ensuring accuracy and meeting all your requirements and deadline. Send me the project details to complete the project soon. For a big project; I have a team of ten member Lebih banyak

€13 EUR dalam 1 hari
(0 Ulasan)

Bonjour , je sait creer des macro avec VBA . Je peut faire un beau travail pour vous. M'ecrir pour en discuter

€66 EUR dalam 10 hari
(0 Ulasan)

1-click to solve the linear programming problem after change each modified cell, using vba for backend work, will keep flexibility to identify all the conditions (if more than 20 cells in future, will still work withou Lebih banyak

€19 EUR dalam 1 hari
(0 Ulasan)
€26 EUR dalam 1 hari
(0 Ulasan)