AutoFilter Speed Issue

Can anyone help me with an alternative to autofilter.

I have no issues when the Size is say 5000 Rows but when i have more records in my sheet excel just times out and ends with an Error.

Note: I am using the statement below within the for loop

Sheets("MergedDataSheetQ").Range(rplRange.Offset(0, 0), rplRange.Offset(sizeData, noColumns + 2)).AutoFilter Field:=noColumns + 1, Criteria1:=SubSector

Is there any work around so that i only change the criteria inside the loop or something like, so that the i reduce the execution time for this statement?