Find Jobs
Hire Freelancers

Create macro for automatic generation of pivot tables and charts

$10-30 USD

已完成
已发布大约 9 年前

$10-30 USD

货到付款
Every 2 weeks we extract excel sheets with a set of performance numbers - see attached examples. I would like to have a master spread sheet where by activating a macro function (that you will build), it automatically "imports" the latest performance numbers from the weekly excel files, creates/updates a pivot table and associated chart. I want the graph chart to display performance over time. I also want a table chart that shows performance of the latest week's numbers compared to the preceding period. The file-naming of the weekly files will be like the examples attached. You will need to build all of the above mentioned functionality: Macro, pivot tables, charts and so on.
项目 ID: 7397802

关于此项目

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

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
I will write macro to extract data from each sheet to populate the master sheet. A form control button will be inserted to automate the data extraction.
$40 USD 在1天之内
5.0 (477条评论)
7.7
7.7
27威客以平均价$49 USD来参与此工作竞价
用户头像
A proposal has not yet been provided
$60 USD 在1天之内
4.9 (164条评论)
6.9
6.9
用户头像
Hey, I am an expert with excel macros as you would see in my work history on freelancer. I can create pivot tables & charts in elegant manner. I can assure you of quality work like I have been doing for past 6+ years as you would see my work history. I have been highly rated and recommended for solutions I provide. Please let me know if you would like me to work on this project for you and we may discuss the details and the next steps. Look forward to hearing from you. Thanks and Regards, Shikha (Automyze Consulting)
$100 USD 在10天之内
5.0 (111条评论)
5.9
5.9
用户头像
Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. I have completed more than 225 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$80 USD 在5天之内
5.0 (107条评论)
6.0
6.0
用户头像
Hi; I am an Excel / VBA coder professional with over ten years experience in developing automated time saving, productivity enhancing applications. I employ the full palette of Excel's features to provide ease of use and to save user time. I have bid based on the weekly data will come in the exact format as per your example: that is 9 columns, and you only need to track the "all" row on a bi-weekly performance basis. Your comments are welcomed. Regards Zenon
$40 USD 在1天之内
4.9 (29条评论)
5.5
5.5
用户头像
Hello, I have checked your file, basically my plan is to create a pivot table and every time we get data you press a button it imports numbers and updates table and charts automatically. Please let me know if there is any question/
$39 USD 在3天之内
4.8 (73条评论)
5.4
5.4
用户头像
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards
$66 USD 在4天之内
5.0 (41条评论)
5.1
5.1
用户头像
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$85 USD 在6天之内
4.8 (41条评论)
4.9
4.9
用户头像
Hi, I can do this very nicely, please check my portfolio and reviews. If you want / need something special I can help you with that. Thanks
$50 USD 在1天之内
4.9 (25条评论)
4.7
4.7
用户头像
Hello, I work a lot with advanced formulas and VBA in the reporting environment for my regular job @Oracle as global reporting analyst so anything you throw at me, if described correctly should be no problem to fix. I have created a couple of similar projects in the past, I could use the templates to speed up the process for what you need. Please let me know if you think you need me and we'll take it from there. my Skype: vasilicutza Thanks!
$77 USD 在1天之内
5.0 (9条评论)
3.7
3.7
用户头像
I designed dashboards, reports and interactive spreadsheets and managed databases for twenty years at a leading multinational. Now work from home in the UK across five freelance sites with good reviews from international clients who have utilised my expertise in VBA Coding, Formulae and Conditional Formatting. I can work under a Confidentiality and Non-Disclosure Agreement if required, and start as soon as you pay the fee into the site. I am happy to send you a sample to let you judge my Excel skill for yourself, but the site does not allow attachments unless you send me a Private Message first. Hope you find this of interest and look forward to hearing from you. Bob Allen-Turl
$103 USD 在2天之内
4.5 (9条评论)
4.3
4.3
用户头像
Hi, I am good at excel and macros... I can create vba. Please see my experience list in the freelancer. I will create vba to meet your requirement with all the conditions satisfied. Looking forward for your reply to start the work on immediately.
$60 USD 在1天之内
5.0 (17条评论)
3.4
3.4
用户头像
Hello! I review attached Excel file and I can help you. My knowledge in Excel (pivot, formulaes, visualization) + VBA are on very high level. I can help you out. Feel free to contact me.
$55 USD 在3天之内
5.0 (9条评论)
3.5
3.5
用户头像
i can do it for you quickly and exactly .
$55 USD 在3天之内
4.8 (14条评论)
3.6
3.6
用户头像
Hello! I work with VBA for last 4 years and have created hundreds of scripts, It will take about 2 hours to make all thing U need, only thing i need template. or more deatails about exact charts\pivots. Hope for Your response. Best regards, Vlad
$35 USD 在1天之内
5.0 (5条评论)
3.1
3.1
用户头像
Dear Sir I can accomplish this job for you. I have previous experience of excel related projects using macro. Kindly contact me for further details. Thanks Tonmoy Roy
$50 USD 在2天之内
5.0 (15条评论)
3.1
3.1
用户头像
I'm interested in this post. I'm proficient with Excel functions and Excel macro. I also have working experiences in excel modeling for Campaign Performance Management and Project Management. My solid skills and working experiences and help me complete this task with good output. Feel free to contact me and provide more information for our started if you're considering hiring me in this task. Looking forward to hearing from you. Sincerely, Vivi
$30 USD 在3天之内
5.0 (1条评论)
1.7
1.7
用户头像
I can also create advanced filter for your table by Visual Basic. But I need your detail requirements.
$35 USD 在1天之内
5.0 (1条评论)
0.7
0.7
用户头像
I have computer engineering degree and working for 3 years. I'm good at using computer and MS office program. I would like to be freelancer for your project. I'm hardworking person. Please hire me :) You ll never regret, if u choose me ;)
$15 USD 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
Have worked as an information analyst for managing database and creating automation templates with MS excel and MS excess.
$30 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
I would like to be a paper where the master spread through the activation of renal function (which will build), it automatically "imports" the latest performance figures of weekly excel files, and create / update a pivot table and graph associated with them. I want the graph to display the chart performance over time. I also want the table schema, which shows the performance numbers are the latest week compared to the previous period. The file of the weekly naming files to be attached to such examples. You will need to build all of the functions listed above: Macro, pivot tables, graphs and so on.
$20 USD 在3天之内
0.0 (0条评论)
0.0
0.0

关于客户

DENMARK的国旗
Lystrup, Denmark
5.0
32
付款方式已验证
会员自10月 14, 2010起

客户认证

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