I have a cell range (D3:J39)
Top row has monday to sunday and first column has different jobs to be done.
now i used colored cells to show the start of a project and another color to signify the end of a project.
can i use VBA to pick out all the colors from the start of a project and display them in a column in a new sheet

Cheers in advance

J