Đã hoàn thành

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

Kĩ năng: Nhập liệu, Excel, Excel Macros, Excel VBA

Xem nhiều hơn: 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

Về Bên Thuê:
( 17 nhận xét ) Salmiya, France

ID dự án: #14868398

Được trao cho:


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 Thêm

$25 USD trong 2 ngày
(14 Đánh Giá)

30 freelancer đang chào giá trung bình $24 cho công việc này


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 Thêm

$15 USD trong 1 ngày
(230 Nhận xét)

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 Thêm

$16 USD trong 0 ngày
(95 Nhận xét)

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. Thêm

$29 USD trong 2 ngày
(90 Nhận xét)

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 Thêm

$30 USD trong 1 ngày
(60 Nhận xét)

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

$25 USD trong 2 ngày
(34 Nhận xét)
$25 USD trong 1 ngày
(22 Nhận xét)

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 Thêm

$25 USD trong 1 ngày
(16 Nhận xét)
$18 USD trong 1 ngày
(9 Nhận xét)

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 Thêm

$25 USD trong 1 ngày
(10 Nhận xét)

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 Thêm

$23 USD trong 1 ngày
(7 Nhận xét)

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 Thêm

$40 USD trong 1 ngày
(2 Nhận xét)

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 Thêm

$35 USD trong 1 ngày
(0 Nhận xét)

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 trong 1 ngày
(0 Nhận xét)

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 trong 1 ngày
(0 Nhận xét)

A proposal has not yet been provided

$20 USD trong 1 ngày
(0 Nhận xét)

creatively design macro for ease Ur work

$15 USD trong 2 ngày
(0 Nhận xét)

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 Thêm

$17 USD trong 1 ngày
(0 Nhận xét)

A proposal has not yet been provided

$20 USD trong 1 ngày
(0 Nhận xét)
$25 USD trong 1 ngày
(1 Nhận xét)
$25 USD trong 1 ngày
(0 Nhận xét)