I have a martrix of data that contains the following
Col A - Project
Col B - Role
Col C to JH - Dates from 1st Jan to 31st Dec
In each cell there will be a number or text to reflect the number of hours worked of whether it is a holiday date
Currently I have about half of the matrix with...