Excel Macro Programming - import an Excel file and transform the data into comfortable sheets - worktime recording

Befejezett Kiadva: 4 évvel ezelőtt Kiszállításkor fizetve
Befejezett Kiszállításkor fizetve

Our telematics platform delivers an xls, xlsx file for a certain period, e.g. 1st of month for last month. This file contains all the tracked data and time stamps an employee has done in that period.

It is far too much information for the average user (craftmen, Service, construction SME companies) to sort out and to handle the data easily for the hour [login to view URL] raw file contains only tracked data. If there is a holiday, vacancies, seminars or illness there is no data.

What we need is an Excel program (macro) which read (Import) that raw tracking data and transforms it into a monthly overview with weekdays.

Please see uploaded files attached.

Goal is to have an Excel sheet with intelligent macros for easy handling of worktime recorded by tracking system.

Excel Visual Basic Visual Basic for Apps Excel Macros

Projektazonosító: #20677046

A projektről

75 ajánlat Távolról teljesíthető projekt Utoljára aktív: 4 évvel ezelőtt

Odaítélve:

paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel macro that will transform data from a raw table into a useful format. I Továbbiak

€1000 EUR 7 napon belül
(251 értékelés)
7.5

75 szabadúszó tett átlagosan 948€ összegű árajánlatot erre a munkára

sandroshubladze

Hello, I am Highly experienced Excel Expert and VBA Developer Can definitely create for you desirable working file If you will be interested, contact me Thanks & Regards

€950 EUR 10 napon belül
(203 vélemény)
8.2
cgullapalli

Hi, Iam good at Excel VBA programming. I have referred the details. I can include the working dates, holidays & ill dates for the dates missing. Looking forward to discuss the project. -chandra

€1176 EUR 7 napon belül
(878 vélemény)
8.0
asin1987

Dear Employer, I have checked both your files and I understand you need to sort out the heavy data files that you have in structured data which can be easily used. I am an expert with over 12 years of experience and w Továbbiak

€750 EUR 7 napon belül
(190 vélemény)
7.7
seaanddream

Hi, my name is Selim. I am from Solihull, UK. I read your `Excel Macro Programming - import an Excel file and transform the data into comfortable sheets - worktime recording` project descriptions carefully before biddi Továbbiak

€900 EUR 10 napon belül
(285 vélemény)
7.8
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Továbbiak

€1200 EUR 12 napon belül
(344 vélemény)
8.0
P0L

Hello, I’m an Excel/VBA expert and I have work experience on many similar projects. I'm fully available and I can start right away. By the way, what's your timeframe for this project? Please check my profile and contac Továbbiak

€900 EUR 5 napon belül
(344 vélemény)
7.4
Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed mor Továbbiak

€900 EUR 7 napon belül
(252 vélemény)
6.9
zebracaro

I can do it for you quickly and exactly .Please contact me for saving your time and your money .

€900 EUR 7 napon belül
(126 vélemény)
7.1
dgled

Hi, I am financial experts and gurus in Microsoft Office, Power BI and /VBA/Macro. I have considerable experience in merging files and manipulating the data in a structured database, especially with importing external Továbbiak

€1000 EUR 7 napon belül
(89 vélemény)
7.1
sargardon

Hello there. Ready to work on your project. Over 15 years of experience in software development including Excel macros. I can also develop you the macro as Excel add-in where whenever you open the files there will be Továbbiak

€770 EUR 7 napon belül
(116 vélemény)
7.0
PigtailXL

Hello Sr./Madam Hope you read my proposal and take a look into my Portfolio to see my reputation and capabilities. I am an experienced Windows Desktop Apps Developer (C#, C++), Web Data Extractor & Automator (using dif Továbbiak

€1000 EUR 10 napon belül
(171 vélemény)
7.1
prameswara

Hello Sir. Im excel vba macro and formula expert. i can do make macro for import your exsting data and can analyze it like you need. please ping me now and im free to start discuss more now. Thank You Galih

€750 EUR 10 napon belül
(372 vélemény)
7.2
zekovicm

Hi there, I can create that complex macro for you without problems. Please feel free to contact me to discuss further details. Best regards Miljan ps Wir können auch gerne Deutsch sprechen :)

€882 EUR 6 napon belül
(120 vélemény)
7.3
asadkhan3533

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan

€750 EUR 10 napon belül
(177 vélemény)
6.7
branislavm

Hello! I am Branislav from Serbia, we are in the same time zone. And I know enough of German to handle files on German. What I am interested in, in the first place, why not a database for this? Such calculations are Továbbiak

€1125 EUR 7 napon belül
(87 vélemény)
6.7
shoguna2m

Hi there, I'm Mauricio, the VBA and MS Excel expert from Trascender Global Team, with 4 years of experience in building VBA based dashboards to manage and visualize temporary information. I've read the details and ch Továbbiak

€1000 EUR 7 napon belül
(122 vélemény)
6.9
MohsanEijaz

I am excel and vba expert, I am interested in your project, lets discuss . Malik

€750 EUR 7 napon belül
(88 vélemény)
6.3
valor312

VERY EASY FOR ME Hi, Nice to meet you. When it comes to Excel, I am an expert Please see product I made recently using VBA and C#, python, java, excel management https://www.freelancer.com/projects/excel/Excel-Macro-p Továbbiak

€750 EUR 7 napon belül
(59 vélemény)
6.2
dvcontact

Hi, Would you like to see a quick demo of your Excel sheet with a macro that reads raw tracking data and transform it into a monthly overview with weekdays before you award the project? You can consider it professional Továbbiak

€1000 EUR 5 napon belül
(53 vélemény)
6.5
shikhamehta

Hello there, I am an expert in Excel and have done several similar projects related to employee time sheet creation. I reviewed both the files you shared and can certainly create a macro that will import the workbook Továbbiak

€750 EUR 7 napon belül
(132 vélemény)
6.5