It looks good. Would it be possible to place it at the beginning of the report? So it would be easier and a lot quicker for me to write the issues from the drop down menu in column C. And we wouldn't have to rewrite the number of the rows

Also, I know I had said I would like the formulas for 1000 rows, would it be possible to go to 3000? My boss will probably want to have I tab for all of the weeks combined and every week will have about 500-600 rows.

Thank you very much!