Macro crashing Excel whilst (not) filtering

Attached workbook goes into non-response mode when asked to set the filter on the DATABASE sheet, and eventually I have to close Excel, but can't see why?

DATABASE worksheet lists names, test dates and results across four tests for Jan - April.

Macro needs to start by filtering Col A of the DATABASE by the Name selected from the DropList in C2 of the PERFORMANCE worksheet, then Transpose the dates and scores into Cols C - F of the PERFORMANCE worksheet.
End result should be as shown in Cols I - M, if Candidate 1 is selected.

But I can't even get it to complete the first step (Filter the Database to show only the name selected).

Please Login or Register  to view this content.

All solutions, suggestions and alternatives welcome as ever

Ochimus

Please try

Please Login or Register  to view this content.