Find Jobs
Hire Freelancers

Build Advanced Excel VBA Templates

min $50 USD / hour

Closed
Posted over 4 years ago

min $50 USD / hour

Wet-it is looking for an experienced freelancer with skills in both VBA Excel and Quick Books Enterprise, in particular Advanced Reporting language. The goal is to streamline repetitive tasks performed in Excel and make templates easy-to run for Less experienced personnel. One of the needed macro-enabled templates, for instance, is a Sales & Rep Analysis report. Data is imported from QB in a csv format and pasted to the file, which should explode into 9 different reports to create commission statements. Although we have already extensively developed a template (including pivot tables and nested IF formulas), we need to automate the process to make this a quick, reliable function. I have provided a few screenshots below of our current templates that need to be enhanced into a macro-enabled format.
Project ID: 20446872

About the project

21 proposals
Remote project
Active 5 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
21 freelancers are bidding on average $51 USD/hour for this job
User Avatar
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. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$50 USD in 40 days
4.9 (342 reviews)
8.0
8.0
User Avatar
Dear Employer, I perfectly understand you want to automate the CSV files that you get from QB and need a VBA so that you can get the desired Excel files. Please message me, I am an expert with over 12 years of experience and will do a perfect job for you. Please do check my reviews once!! Thanks and Regards, Ash
$50 USD in 40 days
5.0 (186 reviews)
7.6
7.6
User Avatar
Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many projects like this. Can you send me a message? Then we can discuss the details. Regards, Noor
$50 USD in 1 day
4.9 (267 reviews)
7.0
7.0
User Avatar
Hello, I have a suggestion for you going by my extensive experience. Let's extend our Excel capabilities as an Excel Add-in written using VSTO using .NET C# language. Though, I am open and equally good with VBA, but I believe, if there is an opportunity to upgrade, we should use it and VSTO is the way forward. This will also, by the order of magnitude, improve our capabilities of integrating our Excel with external tools like QuickBooks as .NET offers a plenty to do this. I have developed one such really sophisticated VSTO Excel Add-in for Unilytics Corporation from Canada and have found it really smart and much more capable than the VBA itself. P.S. - If the client choice still remains with VBA, let's do the best with VBA. No Worries ! I can start immediately on this project and look forward to a long lasting and mutually beneficial association. Best Regards, Nishant Sharma
$50 USD in 40 days
5.0 (1 review)
6.0
6.0
User Avatar
Hi, sir I read your requirement carefully. I can support you well. I have great skills in Excel VBA template developing . I have already completed so many projects and get good reviews from employers. I am sure, I can complete your project! If we have chat, then we can be sure for each other. Let's start this work! Regards
$60 USD in 40 days
5.0 (10 reviews)
5.1
5.1
User Avatar
I am postgraduate with more than 5 years of experience in advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed couple of automation tools for Ernst and Young also. You can get your work done here with highest quality at lowest price. Looking forward to work with you
$50 USD in 40 days
4.9 (34 reviews)
5.2
5.2
User Avatar
Hi, I am ready to start right away. I'm an expert in data entry. I'll provide you with the quick turnaround for this work and I am much interested to assist you with your requirement. Understood your all requirements. Once knock me so we can discuss more. Regards Moushumi
$50 USD in 1 day
4.9 (54 reviews)
4.8
4.8
User Avatar
Hi, I have understand the project requirement & interested to make sales report for this project. I am related with sales since 6 years, i shall make all type of sales analysis report. Please send a message so we can discuss more & start the project. Thanks.
$50 USD in 40 days
5.0 (40 reviews)
4.6
4.6
User Avatar
Hi. How are you? I read your description carefully and am very interesting in your project. I can start right now and can help you. I have many experience in excel, VBA, Macro. I will finish your project wonderfully and perfectly in short time. If you hire me,i will do my best for your job and you can get the best results. Looking forward to hearing from you. Thanks.
$50 USD in 10 days
4.8 (11 reviews)
4.2
4.2
User Avatar
I can do the job! I have Quick Books Enterprise software. I'm an engineer with advanced working knowledge and experience (over 15 years) in Microsoft Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, Outlook, MS Project,MS Visio, Autocad, pdf, CorelDraw, PhotoShop, etc.). Also on web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6, AI (neural networks, genetic algorithms, optimized search, etc). If necessary, we can communicate via voice call (I speak english with an almost native accent because I was raised in USA, Charlottesville Virginia)
$50 USD in 40 days
5.0 (15 reviews)
3.9
3.9
User Avatar
Hi there, I am a vba developer with over 20 years experience writing custom applications for my clients. I have experience extracting data from financial systems like sage 300, business visions and qucknbos and developing custom reports for the end user using automation. I am available to start immediately
$50 USD in 2 days
5.0 (6 reviews)
2.8
2.8
User Avatar
Hi Greetings of the Day, I am interested in this task, I am full time freelancer carrying 15 yrs of experience in Web and Windows development and Mobile development using ASP.Net, C#, SQL server, Xamarin, WebAPI, XML, Cr Reports etc. I have 3 years experience in remote working for US clients. Please feel free to contact me. Thanks
$50 USD in 40 days
5.0 (1 review)
1.8
1.8
User Avatar
Hello dear sir/madam I’m ready to do your project right now as fast / carefully as you want. I have validation method to deliver my projects to the best quality. I had got this experience and have many Excel contain VBA macro samples to show, you should be relax to deliver me your project and enjoy it. Best regards
$50 USD in 50 days
5.0 (2 reviews)
1.0
1.0
User Avatar
I am interested in your project. I am an Excel expert and have a great experience in excel automation with formulas and VBA since my first career 20 years ago. I assured that you will get high quality / high accuracy / high turn around service with the best price
$50 USD in 40 days
5.0 (1 review)
0.0
0.0
User Avatar
Hi, there, I am so glad to hear that clients like you require automated processes in financial reporting. Me myself is a Senior Financial Analyst and I adopted the top-edge Power Suite in Microsoft Excel to automate and expedite my reporting precedures, so efficient that my boss (manager) and her boss (VP of Finance) are over-thrilled at the accuracy and speed in my providing insightful reports. Would love to engage with you over Skype to further explain the state-of-the-art technology I used. Working from PST time zone. Cheers, Len
$60 USD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Forest City, United States
0.0
0
Member since Jul 22, 2019

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.