Käynnissä

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

Hi,

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:

DEPARTURE CITY

TIME SLOT

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 data repost, fill excel spreadsheet data, fill spreadsheet data, create pivot table vsto, vbscript create pivot table, vsto create pivot table, excel create pivot table

About the Employer:
( 15 reviews ) Salmiya, France

Projektin tunnus: #14868398

Myönnetty käyttäjälle:

dayakmlt

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ä
(6 arvostelua)
2.4

31 freelanceria on tarjonnut keskimäärin 24 $ tähän työhön

SBITServices

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ä
(199 arvostelua)
6.9
semi786

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ä
(59 arvostelua)
6.1
MohsanEijaz

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ä
(52 arvostelua)
5.6
sonarkaushik

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)
6.1
asadkhan3533

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

25 $ USD 2 päivässä
(19 arvostelua)
4.5
25 $ USD 1 päivässä
(17 arvostelua)
4.3
18 $ USD 1 päivässä
(9 arvostelua)
3.7
shakerhany

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ä
(13 arvostelua)
3.0
ReneRondon

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ä
(2 arvostelua)
1.5
DataSoftExpertiS

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ä
(1 arvostelu)
1.2
pitr77

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)
0.0
gourisankar805

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)
0.0
khanconsultancy

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ä
(0 arvostelua)
0.0
oooooo2000

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)
0.0
gabrieltabares05

A proposal has not yet been provided

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

creatively design macro for ease Ur work

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

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)
0.0
forhire5

A proposal has not yet been provided

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