Closed

Transform an excel formula to VBA script

Hello,

I have a formula which I want you to transform it to VBA code in order to iterate a list of inputs. The formula needs to work in google sheet.

I enclose you a case file, in order to understand better. The formula is

=$C6*MAX(0,DAYS(MIN($B6,EOMONTH(E$5,0)),MAX($A6,E$5)))/DAYS($B6,$A6)

and corresponds to the value of cell E6.

Columns A,B,C are the input data. I want the script to give me line 10 (green line) as a result.

My budget is 10$

Thanks for your time

Skills: Excel, VBScript, Visual Basic, Visual Basic for Apps

See more: vba formula result value, excel convert formula to value automatically vba, vba vs excel formulas, excel vba if formula in cell, excel automation formulas, excel formula to vba converter online, how to write excel formula in vba code, excel vba convert formula result to text, start vba script excel, run vba script excel, excel vba script modify existing vba, vba script excel xml, vba script excel current worksheet, vba script project excel, can vba script run outside excel, simple excel vba script, excel using custom vba script, excel vba script find text, excel nearest neighbor vba script, paste formula vba excel

About the Employer:
( 2 reviews ) TOULOUSE, France

Project ID: #19294717

21 freelancers are bidding on average $21 for this job

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More

$35 USD in 1 day
(309 Reviews)
7.8
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

$30 USD in 1 day
(88 Reviews)
5.5
lightingdavid

Hello. I have good skills in "Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps". I have working for 7+ years in this field. I 'm very interest to your project. I have checked your project des More

$25 USD in 1 day
(65 Reviews)
5.6
valor312

VERY EASY FOR ME, I can do it within 30 min Hi, Nice to meet you. Please see product I made recently using VBA and C# excel management https://www.freelancer.com/projects/php/create-csv-file-using-parshub/?w=f http More

$30 USD in 1 day
(26 Reviews)
4.9
Mokshith30

Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance T More

$25 USD in 1 day
(33 Reviews)
4.2
maguirrer

Hello, I can help you with this project, please send me a message with some details liks what are the values on gray (I thought it was the days of the range for each month, but the total doesnt match). I can start work More

$10 USD in 5 days
(11 Reviews)
3.2
rickygzz85

I will create a VBA macro to achieve what the formula describes I offer - Quality. Everything organized, excellent grammar, proper indentation comments on the code. - Availability to work full time on this proj More

$15 USD in 1 day
(13 Reviews)
3.3
bluestar1027

Hi Dear. Don't worry for your project, i can do your project completely. Because of i'm dedicated and created developer for project and love to develop for you. if you don't satisfy my result, i will return your mon More

$25 USD in 1 day
(1 Review)
1.8
ArturQQ

I can help you with you vba transition in 5 hours, when I get home, if it will be ok to wait, feel free to accept my bid.

$10 USD in 1 day
(2 Reviews)
1.4
JamesQ13

Hi there Thanks for your time with me I am very happy to meet job matching my skills I have full experience in multi framework and script language. If you give me a opportunity I will help you creatively and perfec More

$25 USD in 1 day
(1 Review)
1.0
Karekin

Hi, How are you today? I have just read your job description carefully and I am very interesting in your job. I am a senior Excel,VBA,C,C++ ,C# developer with 10 years experiences and I have developed many program of More

$20 USD in 1 day
(1 Review)
0.6
arashbahrami1

Hi, I am expert in VBA and web application development and also have experience over 10 years in security and quality assurance fields. I think I can do it for you as soon as possible. In order to see my customers p More

$15 USD in 2 days
(0 Reviews)
0.0
NoSonforhim

I have 20 years in Database Developing, Programming, Training, and Accounting Solutions / Finance with Computer

$22 USD in 1 day
(0 Reviews)
0.0
belleroandres

Hello I am interested in this project I have experience for more than 10 years in vba, in excel, acces and visual basic. my main achievements are costing system, sending mail, alarm, file processing. thank you.

$25 USD in 10 days
(0 Reviews)
0.0
Bassemashraf20

Welcome Sir My name is Bassem Ashraf, Bachelor of Engineering. I work well on AutoCAD, Microsoft Word, Microsoft Excel, Photoshop, excellent translation, printing, Data Entry. It will save you less time, less money More

$25 USD in 1 day
(0 Reviews)
0.0
amitbecs08

Hi Sir, I can complete this task in required time frame. Hoping for positive response from you. Regards Amit Bhadula

$10 USD in 1 day
(0 Reviews)
0.0
dieutech5

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do More

$34 USD in 7 days
(0 Reviews)
0.0
espanajv

Hi, This is too easy, Really please contact me. You'll have your response regarding today is saturday probably in 2 hours. But, its really really too easy. Have fun. And well with my bid thanks for the beer. Chea More

$15 USD in 1 day
(0 Reviews)
0.0
TransGlobal365

Greetings! Are you looking for high quality native manual language transcription? If so, we are here to assist you with your all transcription needs and giving you the guarantee of 100% perfect result without a single More

$10 USD in 0 days
(0 Reviews)
0.0
sagom

Software engineer with a postgraduate in software development and I have extensive experience in the development of web and mobile software, I have worked with business intelligence projects based on Microsoft technolo More

$20 USD in 1 day
(0 Reviews)
0.0