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
18 pekerja bebas membida secara purata €74 untuk pekerjaan ini
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
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
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.