Find Jobs
Hire Freelancers

EXCEL/VBA APPLICATION

$30-250 USD

Completed
Posted about 10 years ago

$30-250 USD

Paid on delivery
Excel VBA Application Objective: - To Create Excel based VBA application which does some macro based work and watch csv file for creation time and run specific codes and also refresh specific excel sheet. Features: 1. Allow user to set source data folder in settings excel sheet or using vba setting box. 2. Allow user to set csv file names in settings excelsheet or using vba setting box. The macros button will use these settings. 3. Allow user to set custom calculation settings in setting excel sheet. 4. Create a VBA based Macro called Run Calculation , which will Create x number of excel sheet and import data from csv file and then do specific calculation and do conditional formatting and adjust the width of specific column. This it will do for all the csv file its listed on settings. 5. Create VBA based Macro where it will take specific column values from each sheet and display it on one spreadsheet as summary. 6. Create VBA based feature where it will monitor when the .csv data file is modified and any new file which has changed then update that excelsheet. Then it will mark that point, after that any new updates to specific data file in source folder then it will update them. 7. After the data file is updated it will list the updated file in separate window where it will list the file name and time it was updated, and when user clicks on the file name it will take the user to that excelsheet. 8. Allow user to set calculation & conditional formatting settings in settings excelsheet. All the calculation is very simple. This is summary of specs. I need Experienced EXCEL/VBA Programmer who can get the job done on fastest time possible. If you work on multiple projects at a time please do not bid.
Project ID: 5391744

About the project

11 proposals
Remote project
Active 10 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
Awarded to:
User Avatar
Hello, I read through your requirements and everything looks like familiar to me. I had done similar kind of assignments before. You can check out my past projects and reviews. I can make sure that the job gets done with in the next 24 hours with no errors. Let me know if you are interested. Thanks
$200 USD in 1 day
5.0 (102 reviews)
6.1
6.1
11 freelancers are bidding on average $193 USD for this job
User Avatar
Hi, I have studied the requirement and can take on the job immediately. Would be helpful if you have sample csv files for my perusal. Let me know. Regards, Arul
$250 USD in 3 days
5.0 (204 reviews)
7.4
7.4
User Avatar
Greatings! I can do this job with perfection. Thank you
$147 USD in 4 days
4.8 (56 reviews)
6.3
6.3
User Avatar
Hi I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% accuracy in minimum time . Pay me only if you are 100% satisfied with my work, after project delivery. I am interested to work for your project. Please give me a chance. I have handled many projects involving data manipulation handling, business solutions, Excel automated dashboards, Report Generation and Excel Applications. If you offer me your project, I can start immediately and deliver the job within 3 days after testing (QA) . I guarantee 100% accuracy for my deliverable. I do hope you'll give me the honorable chance to work with you and help me with making my mark on freelancer.com. I will take your project as the priority job and will complete your work in minimum time with 100% commitment. Thanks Fibin
$225 USD in 3 days
4.9 (53 reviews)
5.4
5.4
User Avatar
Hi, I have worked as pricing analyst for 4+ years. During this stint, I have worked on projects involving elasticity analysis, break-even analysis, regression and price models. In my projects, I work extensively on excel. I have successfully completed similar projects for 'Sadebow'. You may have a look at review provided. Please revert back for any questions/clarifications. Regards! Vikas
$94 USD in 3 days
4.9 (39 reviews)
5.6
5.6
User Avatar
Hi, I build robust, strategic business solutions period. I'm not cheap. There's a reason for that... PEDIGREE / PREVIOUS WORK My pedigree includes these (my own sites and my own developed software): My Excel and Access development site (I also TEACH development): vbafasttrack.com. I recently completed a project to build a Bitcoin trading application, a binomial and trinomial employee stock options model for a mid-tier US investment bank and have an Insto finance and trading background myself. I am also the developer of the following software freelancesniper. Be advised I have my own company doing this stuff and have an institutional IT background. Cheers. SteveP.
$325 USD in 6 days
4.9 (6 reviews)
4.9
4.9
User Avatar
I am good at VBS scripting. I need the first project in freelancer, could you give me a chance, thank you.
$144 USD in 3 days
5.0 (4 reviews)
3.2
3.2
User Avatar
After the project specs are made clear and unambiguous, it will take one or two days to complete. Gene
$333 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I work with this kind of project every day in my current job. You can be sure that i know what you need. I just going to need a exaple of the .csv file (just to see the sheet struct). I also going to need that you tell me the kind of calculation that you need.
$155 USD in 4 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
North Fort Myers, United States
5.0
80
Payment method verified
Member since May 28, 2006

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.