Find Jobs
Hire Freelancers

Convert a Template to a Website

$30-250 USD

已关闭
已发布将近 9 年前

$30-250 USD

货到付款
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.
项目 ID: 7745646

关于此项目

3提案
远程项目
活跃9 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
3威客以平均价$122 USD来参与此工作竞价
用户头像
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 在6天之内
4.5 (4条评论)
1.9
1.9
用户头像
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 在6天之内
5.0 (1条评论)
0.8
0.8

关于客户

INDIA的国旗
Malerkotla, India
4.6
17
付款方式已验证
会员自12月 6, 2014起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。