Færdiggjort

Make alterations to a spreadsheet with a functioning Macro - VBA expert

I have a spreadsheet that works quite well but I need some alterations made to make it work even better.

Currently there is a macro that enables a mathematical function to occur if selected. This effects a group of values - It is the "apply retention" check box. Please see file attached.

Currently this function only has effect on the "Contract stage of Work" table.

What I want to acheive is that when this check box is selected that it wall apply to the "Variations to Contract" table and the summary table at the top.

So here is How retention works, you will need to grasp this concept to be able to complete this task.....

Okay, so in my line of work I have what is called retention.

Retention is 5% of the contract value with held by the client until the end of the job.

Each claim I make against the job, I have to deduct 10% off the claim and repeat this until the retention sum total equals 5% of the contract value.

So at some stage throughout the job I stop deducting the retention because I have reached 5% of the contract value. This what the macro does currently and works perfectly.

So if a project is $100 then retention will be $5. The macro stops any more retention from being deducted from the table.

At the end of the project I can claim this retention back from the client. Basically he holds it as security until practical completion.

So I need someone to make this work for the Variation table and its associated summary table at the top of the spreadsheet.

I think this is a easy task for someone highly competent in VBA coding

This is an urgent request and will need to be completed asap as I need to make a claim tomorrow.

Thank you

Evner: Excel, Visual Basic

Se mere: ftp download file macro vba, project 2007 html export macro vba, vba expert jobs, vba expert freelance, excel vba expert resume, macro vba institute bangalore, vba expert needed, outlook macro vba phone number, vba expert system, excel 2007 macro vba update, example excel macro vba invoicexls forum, macro vba mail pst outlook, vba expert excrl, excel macro vba select copy paste internet explorer, excel filling spreadsheet data macro, deploy macro vba gpo, live clock time macro vba, excel vba open spreadsheet start macro, macro vba expert, expert macro vba di semenanjung

Om arbejdsgiveren:
( 23 bedømmelser ) Margate Beach, Australia

Projekt ID: #21419185

Tildelt til:

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 Flere

$125 AUD på 1 dag
(228 bedømmelser)
6.9

25 freelancere byder i gennemsnit $104 på dette 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 Flere

$200 AUD på 1 dag
(721 bedømmelser)
8.5
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. Pl Flere

$250 AUD in 4 dage
(318 bedømmelser)
7.9
bouslimi1979

Hi, the global idea is clear, but need a short discussion to clarify more this retention logic. I m ready to start. Thanks

$100 AUD på 1 dag
(279 bedømmelser)
7.7
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] Flere

$155 AUD på 1 dag
(91 bedømmelser)
6.7
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 Flere

$100 AUD på 1 dag
(102 bedømmelser)
6.2
dvcontact

Hi, You may not select the right candidate without knowing what your project on making some alterations in an Excel macros will look like. Fortunately, I can complete a part of your job before you award the project. I Flere

$150 AUD in 4 dage
(48 bedømmelser)
6.3
sloker18

With respect to this project I would like to present myself as a candidate for your consideration. I am proficient with Microsoft Excel and macro/VBA development. I read your project descriptions carefully. I checked t Flere

$150 AUD på 1 dag
(88 bedømmelser)
5.9
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

$98 AUD in 3 dage
(45 bedømmelser)
5.6
Ahmed818

Hello, i am expert in this kind of jobs samples of my excel VBA jobs https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/excel/Make-VBA-code-run-itself/ Flere

$55 AUD på 1 dag
(45 bedømmelser)
4.3
rashedkhanrubel

Hi, I have got the project requirement & interested to work for this project. Please send a message so we can discuss more & start the project. Thanks.

$80 AUD in 2 dage
(23 bedømmelser)
4.2
shahinrahimi

Hi, I can immediately start working on your project and will deliver you in the timeframe. I have rich experience in Macro-VBA coding (API, Websacrping, Automation tasks, managing data, .....), and I do my best to save Flere

$90 AUD på 1 dag
(30 bedømmelser)
4.3
ielucerotrad1

I can do the job! I checked the attached excel, looks simple, just a couple of hours. About me: I'm an engineer with advanced working knowledge and experience (over 15 years) in Microsoft Excel and VBA including intera Flere

$50 AUD på 1 dag
(13 bedømmelser)
3.8
AnowarRatul

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

$35 AUD på 1 dag
(23 bedømmelser)
3.6
mowachira77

Hi there. I am available to fix and improve the macro to as you intend. I have 5 years of VBA experience. I have completed more than 50 projects successfully. I fully understand your project requirements and I am ready Flere

$55 AUD på 1 dag
(7 bedømmelser)
3.1
witoon1980

aterations project, I don't familiar with this claim/retention business but I can image from this Excel VBA file how it work. There were 2 ways, apply and not apply retention. Now I think you need another option, it ma Flere

$50 AUD på 1 dag
(3 bedømmelser)
2.0
(1 bedømmelse)
2.0
mattjparker1104

Hello, How are you? I just saw your project description carefully. I am very interested in your project. I have rich experience in Python, PHP, Java, Excel, Word, VBA, Data Entry, Web Search/Scraping. I can help you Flere

$50 AUD in 2 dage
(3 bedømmelser)
1.5
cooperfrank

Hi there, I am a IT professional. I have experience on VB itself (coding and IDE) and VBA macros development for data operations in a spreadsheet. I can do the work with the required thing

$70 AUD in 7 dage
(1 bedømmelse)
0.8
MichealSMoreno

Dear client, how have you been? I've read your project description carefully. It seems that this project suits me perfectly. How about discuss in chat? Waiting for your reply. Best regards.

$150 AUD in 3 dage
(0 bedømmelser)
0.0
Briggs00

Hi, I can complete your work efficiently and cheap. I have worked with VB for more than 7 years. Please fill free to contact me. Best Regards.

$30 AUD på 1 dag
(1 bedømmelse)
0.0