Does anybody have a macro to replace the autofilter function. Autofilter from what I gather has a limit on the number unique values it will display on the drop down menu.

I was thinking of a macro that you type in a keyword which then displays all rows with that key word in.

Any help appreciated.