VBA/Macro for Excel 2016 - Excel AutoFilter Multiple Numbers Using VBA Macro

If you have multiple numbers to filter in a column and the numbers have no pattern then Excel's Filter Search Box or Number Filters won't be able to accomplish this task. You can use the following VBA Macro for accomplishing that:

Just edit the Range and Values of Array as per ur need:




To understand the syntax you can refer to:

Range.AutoFilter Method (Excel) http://msdn.microsoft.com/en-us/library/office/ff19… View Now

urShadoww/Excel-AutoFilter-Multiple-Numbers-Using-VBA-Macro Excel-AutoFilter-Multiple-Numbers-Using-VBA-Macro - The purpose of this VBA Macro is to Filter Multiple Numbers from a Column http://github.com/urShadoww/Excel-AutoFilter-Multip… View Now

Nauman Khan's answer to I have multiple numbers to filter in excel is it possible to type all numbers at once in excel filter search box? - Quora http://www.quora.com/I-have-multiple-numbers-to-fil… View Now

-urShadow


Reference: http://stackoverflow.com/questions/21834701/use-autofilter-on-more-than-2-criteria