Find Jobs
Hire Freelancers

Create macro for automatic generation of pivot tables and charts

$10-30 USD

Ukończony
Opublikowano około 9 lat temu

$10-30 USD

Płatne przy odbiorze
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.
Identyfikator projektu: 7397802

Informację o projekcie

27 ofert
Zdalny projekt
Aktywny 9 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
Przyznano:
Awatar Użytkownika
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 w 1 dzień
5,0 (477 opinii)
7,7
7,7
27 freelancerzy składają oferty o średniej wysokości $49 USD dla tej pracy
Awatar Użytkownika
A proposal has not yet been provided
$60 USD w 1 dzień
4,9 (164 opinii)
6,9
6,9
Awatar Użytkownika
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 w 10 dni
5,0 (111 opinii)
5,9
5,9
Awatar Użytkownika
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 w 5 dni
5,0 (107 opinii)
6,0
6,0
Awatar Użytkownika
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 w 1 dzień
4,9 (29 opinii)
5,5
5,5
Awatar Użytkownika
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 w 3 dni
4,8 (73 opinii)
5,4
5,4
Awatar Użytkownika
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 w 4 dni
5,0 (41 opinii)
5,1
5,1
Awatar Użytkownika
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 w 6 dni
4,8 (41 opinii)
4,9
4,9
Awatar Użytkownika
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 w 1 dzień
4,9 (25 opinii)
4,7
4,7
Awatar Użytkownika
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 w 1 dzień
5,0 (9 opinii)
3,7
3,7
Awatar Użytkownika
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 w 2 dni
4,5 (9 opinii)
4,3
4,3
Awatar Użytkownika
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 w 1 dzień
5,0 (17 opinii)
3,4
3,4
Awatar Użytkownika
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 w 3 dni
5,0 (9 opinii)
3,5
3,5
Awatar Użytkownika
i can do it for you quickly and exactly .
$55 USD w 3 dni
4,8 (14 opinii)
3,6
3,6
Awatar Użytkownika
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 w 1 dzień
5,0 (5 opinii)
3,1
3,1
Awatar Użytkownika
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 w 2 dni
5,0 (15 opinii)
3,1
3,1
Awatar Użytkownika
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 w 3 dni
5,0 (1 opinia)
1,7
1,7
Awatar Użytkownika
I can also create advanced filter for your table by Visual Basic. But I need your detail requirements.
$35 USD w 1 dzień
5,0 (1 opinia)
0,7
0,7
Awatar Użytkownika
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 w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Have worked as an information analyst for managing database and creating automation templates with MS excel and MS excess.
$30 USD w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 3 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga DENMARK
Lystrup, Denmark
5,0
32
Zweryfikowana metoda płatności
Członek od paź 14, 2010

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.