Đang Thực Hiện

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

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

Xem thêm: 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ê:
( 16 nhận xét ) Salmiya, France

Mã Dự Án: #14868398

Đã trao cho:

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

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

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

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

$15 USD trong 1 ngày
(199 Đánh Giá)
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 Thêm

$16 USD trong 0 ngày
(59 Đánh Giá)
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 Thêm

$30 USD trong 1 ngày
(52 Đánh Giá)
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. Thêm

$29 USD trong 2 ngày
(90 Đánh Giá)
6.1
asadkhan3533

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

$25 USD trong 2 ngày
(19 Đánh Giá)
4.5
$25 USD trong 1 ngày
(17 Đánh Giá)
4.3
$18 USD trong 1 ngày
(9 Đánh Giá)
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 Thêm

$25 USD trong 1 ngày
(13 Đánh Giá)
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 Thêm

$23 USD trong 1 ngày
(2 Đánh Giá)
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 Thêm

$40 USD trong 1 ngày
(1 Đánh Giá)
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 trong 1 ngày
(0 Đánh Giá)
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 Thêm

$35 USD trong 1 ngày
(0 Đánh Giá)
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 Thêm

$25 USD trong 1 ngày
(0 Đánh Giá)
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 trong 1 ngày
(0 Đánh Giá)
0.0
gabrieltabares05

A proposal has not yet been provided

$20 USD trong 1 ngày
(0 Đánh Giá)
0.0
joshwin77

creatively design macro for ease Ur work

$15 USD trong 2 ngày
(0 Đánh Giá)
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 Thêm

$17 USD trong 1 ngày
(0 Đánh Giá)
0.0
forhire5

A proposal has not yet been provided

$20 USD trong 1 ngày
(0 Đánh Giá)
0.0
$25 USD trong 1 ngày
(1 Đánh Giá)
0.0
$25 USD trong 1 ngày
(0 Đánh Giá)
0.0