In Progress

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

Skills: Data Entry, Excel, Excel Macros, Excel VBA

See more: 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

About the Employer:
( 17 reviews ) Salmiya, France

Project ID: #14868398

Awarded to:

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 More

$25 USD in 2 days
(14 Reviews)
3.5

30 freelancers are bidding on average $24 for this job

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 More

$15 USD in 1 day
(230 Reviews)
7.0
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 More

$16 USD in 0 days
(95 Reviews)
6.4
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. More

$29 USD in 2 days
(90 Reviews)
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 More

$30 USD in 1 day
(60 Reviews)
5.8
asadkhan3533

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

$25 USD in 2 days
(34 Reviews)
4.9
$25 USD in 1 day
(22 Reviews)
4.3
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 More

$25 USD in 1 day
(16 Reviews)
3.4
$18 USD in 1 day
(9 Reviews)
3.7
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 More

$25 USD in 1 day
(10 Reviews)
3.2
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 More

$23 USD in 1 day
(7 Reviews)
2.6
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 More

$40 USD in 1 day
(2 Reviews)
1.6
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 More

$35 USD in 1 day
(0 Reviews)
0.0
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 in 1 day
(0 Reviews)
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 in 1 day
(0 Reviews)
0.0
gabrieltabares05

A proposal has not yet been provided

$20 USD in 1 day
(0 Reviews)
0.0
joshwin77

creatively design macro for ease Ur work

$15 USD in 2 days
(0 Reviews)
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 More

$17 USD in 1 day
(0 Reviews)
0.0
forhire5

A proposal has not yet been provided

$20 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(1 Review)
0.0
$25 USD in 1 day
(0 Reviews)
0.0