Completed

Excel Macro to find best result in a database

I need someone to do an excel VBa logic for me that is:

Create a loop to read the Column A from A7 to A(last cell in the column A) after that, calculate the best solution like that:

In the column E we have “heights” of iron billets. The sum I’ll have to create the best iron billet (12meters is the best result) and you can only sum 3 different heights (like 7+3+2 = 12m total)

After that give a results to the operator that clicked in the “button”like that: the best solution is to create a iron billet using the A6 + A87 + A334 = A total 12m)

It’s very short code. Also I want you to make up the first page, doing a small form to enter with user id and password in the excel file.

Skills: Excel, Excel VBA

See more: excel vba find cell address based on value, vba code to search data in excel, excel vba find string in row, improve excel performance with large files, excel performance test, excel vba find range of cells with values, excel vba match value in range, excel vba find string in cell, convert dat database file excel, excel macro enter data database, macro script update database excel, excel macro reading file, dat file excel macro, excel macro export column text file, excel macro browse print file path, excel macro read text file, excel macro write xml file, excel macro file names directory, excel macro exporting row text file, excel macro find text word file

About the Employer:
( 2 reviews ) Belo Horizonte, Bouvet Island

Project ID: #21412745

Awarded to:

maguirrer

Hello, I can help you with your file, but can you send me a message with more details, and if its possible with the file attached as an example and will start working on it immediately.

$17 USD in 2 days
(25 Reviews)
3.9

55 freelancers are bidding on average $28 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g More

$50 USD in 2 days
(714 Reviews)
8.5
zebracaro

I can do it for you quickly and exactly .Please contact me for saving your time and your money .

$45 USD in 1 day
(111 Reviews)
7.0
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje More

$30 USD in 3 days
(224 Reviews)
6.9
TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

$50 USD in 1 day
(325 Reviews)
6.8
nagyzoltan68

Hello, I would like to work on your project. I have great experience using excel macros / vba, formulas and calculations. In order to complete this work I will need sample data with some records and result to be sure I More

$30 USD in 1 day
(121 Reviews)
6.5
polarjin2017

Hello? How are you? I am excited to work with you on this project. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom formula, etc... [login to view URL] More

$25 USD in 1 day
(92 Reviews)
6.7
mateenbhatti94

Dear sir I have read the requirements and completely understand the project. I have been in this industry for 1 year and such jobs are my daily practice. I can assure you that if you work with me once, you will always More

$30 USD in 1 day
(71 Reviews)
6.2
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$50 USD in 1 day
(125 Reviews)
5.9
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible More

$20 USD in 1 day
(55 Reviews)
5.7
Devrits

I have read your all given information in description and i am ready to do various type of work for you and available 24*7*365 for you. 1* I can do Data RESEARCH from any platform for certain subjects. 2* I can create More

$20 USD in 1 day
(47 Reviews)
5.8
razvancotofana

Hello, I am interested in your project. I am an expert in excel and VBA, and I am sure that I can help you. Please send me a message so that we can discuss in details your requirements. Looking forward to hearing from More

$50 USD in 2 days
(16 Reviews)
5.3
sonarkaushik

Sir,      I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards

$29 USD in 2 days
(43 Reviews)
5.5
AkilaArun

Hi, I am interested in working on the task. I have experience working with excel formulas,excel VBA, Data Analysis(Statistically and Graphically) and in creating dashboards. Read the requirement of creating login page More

$30 USD in 2 days
(40 Reviews)
5.0
paulodayto08

Hi Good Day! A serious freelancer here. I can help you to complete this project. Can you share to me your file if you have? I can make it automated using Excel Formulas and VBA Macro. I can show you some sample of my More

$30 USD in 1 day
(35 Reviews)
4.4
KozlouAlex

Hello. Below is almost same project done by me recently: https://www.freelancer.com/projects/data-entry/VBA-for-Microsoft-Excel/details I will be able to complete this job today

$18 USD in 1 day
(22 Reviews)
4.4
vano101

Hello I have several years of experience with Visual basic and Excel macros It looks like elementary task can be done in few hours

$20 USD in 1 day
(34 Reviews)
4.7
StormLion227

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert VBA programmer on freelancer.com and I do not bid on More

$25 USD in 0 days
(28 Reviews)
4.6
GopalJp

This is Gopal. I am extremely good with Excel as it is part of my daily professional work. Working with complicated formula and Developing Macro programs are part of my daily deliverable. I am a professional account More

$100 USD in 7 days
(12 Reviews)
4.4
writingapp

Hi. Great app writer for your projects. I have writen scraping, excel, googlesheet, csv, database app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile

$25 USD in 1 day
(14 Reviews)
4.3
AnowarRatul

$ 10 Only ------ In just 2 Hours ------ Excel VBA Macro & Formula Expert ------ 100% satisfaction first, then payment.

$10 USD in 1 day
(31 Reviews)
3.9