Hi
Try this
1) Change the formula in B4 to be
=IF(VLOOKUP(A4,'Mandatory test - normal scope'!$A$3:$F$64,VLOOKUP($C$1,{"ABL",4;"ID",5;"FACTORING",6},2,FALSE))="y",VLOOKUP(A4,'Mandatory test - normal scope'!$A$3:$F$64,2),"")
Copy down to B65
2) Remove the formula from B66
3) Add the following code to the drop down box
Private Sub ComboBox1_Change()
Application.EnableEvents = False
Sheets("test matrix").Range("a4").Select
Range("a4:c65").Sort key1:=Range("c4"), order1:=xlAscending, header:=xlNo
Application.EnableEvents = True
End Sub
Tony