Hi all,
Everyday the department receives an email with the daily tasks. In the body of email (not any attached excels) there is a table with the following format:
John Doe Kitchen / Cleaning
Max the Driver Driving / Delivering / Reporting
Charles Mg Reception
Nick Pet Maintenance / Reporting
Some people may have one task, while others may have two or more separated each time by a "/".
When this table is copied to an excel (sheet2) it creates a table with two columns, the first being the names (A1 downwards) and the second being the tasks (B1 downwards). In sheet 1 there is a list with all the names on column A (A2 - A30) and all the tasks in row 1 (B1-P1). Length of both columns and rows might change as people might be hired/fired and tasks be removed / added. This will be known in advance though.
So we have a grid of names and tasks (sheet1). The scope here is to create a monthly report of tasks that is adding the task table in sheet 2 and run a macro perhaps to auto count the tasks for each person and add a count (1,2 etc) to sheet1. Since tasks are daily and the report will be monthly, tasks will have to be added (summed up) in the grid from the second day onwards.
Any help would be greatly appreciated.
Thank you in advance
Bookmarks