Develop an Excel macro capable of extracting data from multi-tab spreadsheet

Develop an Excel macro/program capable of extracting data from a team timesheet.

The team timesheet consists of :

- A personnel tab containing the names and details of team members (25 maximum; in rows)

- Six weekly tabs containing a list of 500 potential activities (in rows) and 25 groups of columns (each 5 columns wide – one per day of the week per team member). When a team member performs a given activity on a given day, they input the % of their daily time spent on the activity.

We are looking for someone to develop an Excel macro/program (compatible with Excel 2013) which performs the following functionality :

- Accepts a file name corresponding to an Excel team timesheet file

- Opens the file

- Processes all six weekly tabs

- For each weekly tab : identifies all non-zero cells (i.e. an activity on which a team member has spent time on a given day) and creates an output line containing : team member details from the personnel tab; activity details; the % value that indicates the time spent by the individual.

- Produces a CSV file with all the output lines.

We will provide :

- The desired format of the output CSV file

- A sample team timesheet file with full data

Kemahiran: Visual Basic, Destop Windows

Lihat lagi: data mining excel macro, creating spreadsheet data processing excel, show data form excel macro, check refresh data status excel macro, data internet excel macro, data cleaning excel macro, data clean excel macro, data management excel macro, copy data cell excel macro, data web excel macro

Tentang Majikan:
( 4 ulasan ) Paris, France

ID Projek: #10097957

Dianugerahkan kepada:


Hi, i m serious freelancer with 100% completion rate and i believe i can create this macro for you. I've done many similar jobs without any problems. If you are interested can you send me those sample files (team times Lagi

€50 EUR dalam sehari
(49 Ulasan)

18 pekerja bebas membida secara purata €74 untuk pekerjaan ini


Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among Lagi

€100 EUR dalam 2 hari
(149 Ulasan)

Hello I'm interesting your project very well I'm a Good VBA, Excel, Math, Algorithm expert. I m quite well experienced in these jobs. Let's go ahead with me I want to service for you continously. Thanks

€65 EUR dalam 2 hari
(25 Ulasan)

Hey, I am an expert in Excel and have done several similar projects that allow the user to select the file and then do the desired processing and present the results, all on click of a button. If you could share Lagi

€75 EUR dalam 5 hari
(49 Ulasan)

Hi, I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done good amount of work in excel m Lagi

€100 EUR dalam 6 hari
(70 Ulasan)

Hi there, I have a vast exprience in Excel and VBA and would be happy to help you on the p[roject. Best regards, Eugene

€34 EUR dalam sehari
(79 Ulasan)

Hi, I am good at Excel and vba macros. Please provide me the files. Looking forward to discuss inline with the description provided.

€100 EUR dalam 2 hari
(56 Ulasan)

Hello, I am Excel and VBA expert. Can I see the files? Please note that I have 100% completion rate and 5-star feedback on projects

€100 EUR dalam 10 hari
(20 Ulasan)

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Acc Lagi

€111 EUR dalam 5 hari
(5 Ulasan)

Hello., client I have read your job post carefully. I have rich experience in Excel+VBA. If you hire me, i can complete within 5hrs Thanks Best regards

€66 EUR dalam 10 hari
(3 Ulasan)

Hi sir, I am very interested in your project and offer my services. I have solid skills in Visual Basic and Excel and I can provide best solution in timely manner. I think you like to merge data from all shee Lagi

€88 EUR dalam 3 hari
(3 Ulasan)

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

€75 EUR dalam 3 hari
(13 Ulasan)

Hi, Experienced Excel VBA and VB.Net Programmer. Expertise in Exchange data between sheets, Critical Programming, Developing System for Management and Creating Reports. I've read and understood your project d Lagi

€45 EUR dalam 3 hari
(16 Ulasan)

I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I Lagi

€34 EUR dalam sehari
(8 Ulasan)

Hi (Bonjour) , I am interested by your offer: Excel VBA code . I will be happy to do this job even though I'm new in the field of freelance. Let me know more details of this work. I will start working immediat Lagi

€66 EUR dalam 2 hari
(3 Ulasan)

Hello More 20 years programming experience. I need more details to set real price and time. Regards. ----------------------------------------------------------------------------------------------------------------- Lagi

€100 EUR dalam 7 hari
(1 Ulasan)

Dear Sir or Madam, I propose to solve the task by using a macro in a separate Excel file. I'd like to take a look at the source files to make sure I've understood the task properly. Best regards, Alexander.

€40 EUR dalam 3 hari
(1 Ulasan)

Dear Customer, Please send me the sample files and I will send You back the macro which will do the job for You. All the best ! Zoltan

€66 EUR dalam sehari
(1 Ulasan)

Hi there! I have been working on Macro Programming in MS Office since 2010. So, I am completely capable to do this application easily. 7 days is the maximum scheduled day for me to be able to get this application perf Lagi

€77 EUR dalam 7 hari
(0 Ulasan)

hello,i'm a professional app developer,i've just checked your project report,i'm able to perform your task and you'll be interesting with me,please come in contact with me if you wanna discuss for more project details Lagi

€85 EUR dalam 3 hari
(1 Ulasan)

Hello, my name is Horacio. I've 5+ years working with applications for MS Office 97, 2000, 2003 and now 2010, mostly on Excel and Access macros, VBA programming. I can install 2013 to check compatibility. I'm l Lagi

€83 EUR dalam 10 hari
(0 Ulasan)