Fill a table using data from another table

Hi,

I want to fill out the table on Work Sheet 2 showing employee performance, using data from the Audit Schedule Sheet.


Taking August as an example month, Jobs Assigned need to be counted from the persons initials in the cells from AM29 to AP43. There will usually be 1 job in each column, 4 per month.

Jobs Completed are shown from AM78 to AP92 with a row for each person. A red cell background indicates that a job was completed by that person in that month.


Do I need VBA to do this?

Is it possible to use the red background to count how many jobs were completed, or would it be easier to mark them with an "X" or a "1"?

Ideally I want the table to automatically update when the original table is changed.

Hope someone can help!
Thanks.