Pages

Wednesday, May 25, 2016

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)
Clip Betterhttp://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
Clip Betterhttp://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
Clip Betterhttp://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

No comments:

Post a Comment