Any one know for what Auto Filter uses?
I'm not sure what you mean. Can you specify your question?
Take a look at the help file, look for"Ways to find values in a list by using filters (Overview)"
AutoFilter lets you drill down to specific data you want to see. Additionally,you can use it in VBA filter for data you want to delete, which is ways fasteron long tables than looping through long tables.