Find Jobs
Hire Freelancers

Convert a Template to a Website

$30-250 USD

Closed
Posted almost 9 years ago

$30-250 USD

Paid on delivery
I am looking for an Excel and VBA Expert.  We have a previously built a macro in an excel file that takes an internal report and converts it to a client facing report by the click of a "CONVERT" button. This job involves analysing the existing script and understanding how it works in fine detail. Once it is understood, we need the following changes/updates made: 1. Remove data filters from all worksheets before converting (on clicking the CONVERT button, this will happen before the actual conversion occurs) 2. Save the internal document before running the macro script.(on clicking the CONVERT button, this will happen before the actual conversion occurs) - Before saving, lock all previous date data with password. Then save it, then convert it. Idea is that once the data has been converted, you cant change the old (internal file) data on the template file without a password. 3. Currently, a folder is created for month if it doesn't exist already (taking the last month from the data worksheet and creating a folder - i.e for January the folder is called 01). We need to create a folder for year as well if it doesn't exist yet (for 2015 - '15') I will supply the original project scope to give context of what the actual macro does, to help find the best way to achieve the above without breaking the existing implementation:[login to view URL]  You must have previous experience doing a similar task. Please provide evidence of this in your proposal. NOT: proposals without relevant experience and supporting documentation to show proof of this will not be considered at all.
Project ID: 7745646

About the project

3 proposals
Remote project
Active 9 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
3 freelancers are bidding on average $122 USD for this job
User Avatar
Please have a look at the project I completed https://www.freelancer.in/jobs/php/Reworking-large-vba-project-debug/ This project included an invoicing and inventory management in excel using VBA. The macro file already existed but was outdated and was full of errors, I corrected in approx 10 days. Do send me a message, then I will be able to send you that excel file.
$100 USD in 6 days
4.5 (4 reviews)
1.9
1.9
User Avatar
having 4+ years of experience in VBA and excel automation and I have done a couple of similar macros and expert in understanding the existing macros and I am sure that I can complete the task as described and if needed I can send u my previous project samples u can have a look and award me the project
$111 USD in 6 days
5.0 (1 review)
0.8
0.8

About the client

Flag of INDIA
Malerkotla, India
4.6
17
Payment method verified
Member since Dec 6, 2014

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.