Find Jobs
Hire Freelancers

Excel UI macros for updating dates and amounts in an Excel Gantt chart (VBA macro-based app)

$30-250 USD

Closed
Posted over 3 years ago

$30-250 USD

Paid on delivery
I have a spreadsheet that shows project timelines over months and years. Each timeline has 4-5 set milestones that are scheduled out across the months of the timeline (basically, milestone 1 is a month, milestone 2 is a month, milestone 3 is a month, etc). When I want to update one of the milestones now, I manually do it and then adjust all of the subsequent milestones manually. In between some of the milestones there are monetary values that also need to move commensurately -- and the amounts to be spread out over the those months based on a set formula. The project is to create a macro-based (VBA) user interface within the excel file that that would allow me to move the milestones dates and amounts in an automated way. I want to enter the event dates and amounts in the macro app and have them update the events in the gantt timeline.
Project ID: 28229317

About the project

20 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
20 freelancers are bidding on average $193 USD for this job
User Avatar
Hi, Greetings! ✅checked your project details: Excel UI macros for updating dates and amounts in an Excel Gantt chart (VBA macro-based app) ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast
$220 USD in 4 days
4.9 (440 reviews)
8.3
8.3
User Avatar
Hi, I am expert in Excel macros and like to handle the project after we talk about it. Send to me a message to start our discussions.
$277 USD in 7 days
5.0 (57 reviews)
7.7
7.7
User Avatar
Hello, I am an Australian-based software developer with significant experience in developing easy-to-use User Interfaces. I will easily be able to create a simple interface that will automate your Project timelines and costs. Should you have any questions, please feel free to reach out via PM.
$167 USD in 3 days
5.0 (28 reviews)
5.8
5.8
User Avatar
I have read your project description and it meets to my expertise. I will complete your requirement in quick turn around with right quality. Send me your file to review and I will let you know how fast I can solve it. Contact me soon.. I am an Excel VBA expert having 7+ years of experience in working for numerous projects across the globe. My works includes: 1. Project Dashboards, Employee tracker 2. Userforms, Automated calculations, pivots and graphs 3. Data consolidation using macro. 4. Share point and SQl connection from excel - Data retrieval and upload 5. Calendar creation 6. Import/Export data 7. Web scraping etc 9. Button creation on ribbon using xml My service includes: 1. Coding with proper comments for future use 2. Suggestions on improvement areas apart from client requests 3. First time configuration at right time Looking for positive response from you.
$278 USD in 5 days
5.0 (9 reviews)
4.2
4.2
User Avatar
Hi! Im an Excel VBA and Google Sheets expert. I can help you with ypur proyect, im open to work in a previuos study of technical solution before get hired. Regards, Juan
$150 USD in 5 days
5.0 (15 reviews)
4.4
4.4
User Avatar
Hello there, I'll help you with this macro, so it'll work perfect and fast. I've developed several Gantt diagrams before, so I know exactly what you need. Let me know then, Best regards, JoseLuis
$114 USD in 2 days
5.0 (10 reviews)
3.1
3.1
User Avatar
Good evening! I can help you with this project, Im an excel expert and Im also certified as Green Belt and Project Management, so I complete understand the usage of an CPM/Pert and Gantt Graphics. If you are interested please contact.
$278 USD in 6 days
5.0 (1 review)
2.6
2.6
User Avatar
Hi, I have extensive experience in Excel leveraging VBA to automate various tasks. Lets connect and discuss in detail. Looking forward to a fruitful relationship. Regards Varinder
$140 USD in 7 days
5.0 (1 review)
1.1
1.1
User Avatar
I write VBA function in Excel along with formulas. basically I will update automatic feature you need to apply using VBA for Gantt charts in your PMS application. anuj
$75 USD in 2 days
0.0 (4 reviews)
1.7
1.7
User Avatar
Hi I have an interesting background in excel and VBA. I'll be ready to provide the needed service. Looking forward to your reply. Best regards! Yassine.
$250 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Former RAD developer on the trading floor, turned project manager, I understand your need and think I can deliver in a day. Rgds Phil
$140 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Boston, United States
0.0
0
Payment method verified
Member since Nov 29, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.