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)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。