Fill in a Spreadsheet with Data + Modify a Dashboard + create Pivot Table


I need some one who KNOWS MACROS and ideally VBA.

I usually have a lot of small job (10 to 30 US$) all along the month.

Therefore I need someone who can react quickly and work quickly for reasonable price and who is truely good in MACRO and VBA and fast in DATA ENTRY.

Actually I have a micro project.

I have 1 file called DASHBOARD that contains a Dashboard (diagram) and source DATA.

This diagram shows the DEPARTURES CITIES and the ARRIVAL cities until April 2017.

In that diagram we can choose/change:



but we cannot change the Arrival city (all are showing by default).

I have another file called TAB9.

Tab 9 is used to fill the Source DATA that is in the Dashboard file.

The DASHBOARD file was filled with data until April 2017 (04-17).

I have now the data for 05-17 and 06-17.

The job:

I need someone to

Add the data to the Dashboard file


transform the diagram so that we can also choose the arrival cities


create a macro that will allow DASHBOARD file to "auto-fill" whenever TAB9 file has new data for new month = click on a button in DHASBOARD to import the data from TAB9.

It is a micro project.

No need to bid for 50 or 30 us$.

Check the files in attachment

Taidot: tiedonsyöttö, Excel, Excel Macros, Excel VBA

Näytä lisää: how to create dashboard in excel 2010, pivot table templates free download, dashboard excel free download, excel dashboard using slicers, how to create a dashboard using pivot tables and charts in excel (part 1), pivot table dashboard excel 2010, pivot table template excel 2013, excel pivot table templates, fill spreadsheet with data, copy typing, Fill-Spreadsheet-with-Contact-Data/, https www freelancer com projects data entry fill spreadsheet with data 10799431, https://wwwfreelancercom/projects/data-entry/fill-spreadsheet-data-entry/, fill spreadsheet with data, data-entry/fill-spreadsheet-with-data-entry, fill spreadsheet data repost

Tietoa työnantajasta:
( 17 arvostelua ) Salmiya, France

Projektin tunnus: #14868398

Myönnetty käyttäjälle:


Let me know if interested ............ Presently graph connected to TA9 data . Will provide button in front sheet, if you click it, it will import all data from TAB9 file) to present sheet. Relevant Skills and Experie Lisää

$25 USD 2 päivässä
(14 Arvostelua)

30 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello , I have read your project description and understood your requirement. I have 5 years experience already worked in UpWork, Elancer also. Relevant Skills and Experience Skills : Excel, Macros, Web scraping, Data Lisää

$15 USD 1 päivässä
(230 arvostelua)

Hi Sir/Mam, I am expert in advance excel and VBA. Please review my profile. My profile is suitable for this project. I can complete this project on time. Thank You, Semi786 Proposed Milestones $16 USD - complete tas Lisää

$16 USD 0 päivässä
(95 arvostelua)

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. Lisää

$29 USD 2 päivässä
(90 arvostelua)

It is my great honor to apply for this vacant job. I am very hardworking and can work effectively as fast as I can. I have excellent skills in VB, VBA, C++, C#, OPPs, HTM Relevant Skills and Experience Excel Proposed Lisää

$30 USD 1 päivässä
(60 arvostelua)

Please review my profile as I have relevant experience and skills matching this project. Thanks, Asad khan

$25 USD 2 päivässä
(34 arvostelua)
$25 USD 1 päivässä
(22 arvostelua)

Hi, I've checked the project description and the attachment, and it will be a great pleasure for me to start working on your project now, Relevant Skills and Experience I've more than 8 years of experience in creating Lisää

$25 USD 1 päivässä
(16 arvostelua)
$18 USD 1 päivässä
(9 arvostelua)

Hi i am interested in your project i can give you satisfactory work Relevant Skills and Experience i can work as per your standard time zone as well i have much experience related to your project please consider me fo Lisää

$25 USD 1 päivässä
(10 arvostelua)

Hi. I`m bidding for this project because I am a professional with lot of experience in MS Excel and macros Habilidades y experiencia relevante I guarantee you an accurate job, proper formatting and fast delivery; all Lisää

$23 USD 1 päivässä
(7 arvostelua)

Hi, I'm an enthusiastic and professional data entry specialist. I'm quick to grasp new ideas and concepts and to develop creative solutions to problems. Relevant Skills and Experience Accurate, fast keying skills and Lisää

$40 USD 1 päivässä
(2 arvostelua)

Hi, I'm Intrested to work in your tasks. with reasonable prize. As you said i have good Experience in using the Excel , and Macro creation for small projects quickly.. Relevant Skills and Experience Im new to freelanc Lisää

$35 USD 1 päivässä
(0 arvostelua)

Hello, I work with access and excel macros and VBA in my job. I can start with your project now. I you want to check me, just send me details and I can start. Peter

$40 USD 1 päivässä
(0 arvostelua)

I understand your task and I will do it Relevant Skills and Experience VBA Proposed Milestones $15 USD - 1 step Additional Services Offered $3 USD - I recommend changing the format of incoming data

$15 USD 1 päivässä
(0 arvostelua)

A proposal has not yet been provided

$20 USD 1 päivässä
(0 arvostelua)

creatively design macro for ease Ur work

$15 USD 2 päivässä
(0 arvostelua)

Hello, I have read your job description very well.I can deliver the project on time.I can complete this job within the required time period. Regards Subha Sathi Relevant Skills and Experience I have 2 years experienc Lisää

$17 USD 1 päivässä
(0 arvostelua)

A proposal has not yet been provided

$20 USD 1 päivässä
(0 arvostelua)
$25 USD 1 päivässä
(1 arvostelu)
$25 USD 1 päivässä
(0 arvostelua)