Excel Autofilter Archives

Excel Autofilter

How to Use Custom Autofilter in Excel for More Than 2 Criteria

Oct 1, 2023

Excel spreadsheet can be used for Custom Autofilter for more than 2 criteria. This filter option is particularly useful for sorting a dataset. In ...

How to Use Custom Autofilter in Excel for More Than 2 Criteria

Excel VBA: Remove AutoFilter If It Exists (7 Examples)

Oct 2, 2023

Microsoft Excel offers multiple ways to remove an AutoFilter from a worksheet or an Excel table. In this article, you will learn 7 methods to remove ...

Excel VBA: Remove AutoFilter If It Exists (7 Examples)

VBA to AutoFilter with Multiple Criteria on Same Field in Excel (4 Methods)

Oct 1, 2023

Excel’s AutoFilter feature is really efficient in extracting data based on certain conditions. Implementing VBA is the most effective, quickest, and ...

VBA to AutoFilter with Multiple Criteria on Same Field in Excel (4 Methods)

Excel VBA to Check If AutoFilter is On (4 Easy Ways)

Oct 1, 2023

Excel’s AutoFilter feature is really efficient in extracting data based on certain conditions. But sometimes due to technical issues, AutoFilter gets ...

Excel VBA to Check If AutoFilter is On (4 Easy Ways)

How to Autofilter Values Not Equal to a Certain Value with VBA in Excel

Oct 2, 2023

In this article, I’ll show you how you can auto-filter values that are not equal to a certain value with VBA in Excel. You’ll learn to auto-filter ...

How to Autofilter Values Not Equal to a Certain Value with VBA in Excel

VBA Autofilter: Sort Smallest to Largest (3 Methods)

Oct 2, 2023

While working with large Microsoft Excel, sometimes we need to sort our data from smallest to largest. We can easily do that by using the VBA Macros. ...

VBA Autofilter: Sort Smallest to Largest (3 Methods)

[Fix]: AutoFilter Method of Range Class Failed (5 Solutions)

Oct 1, 2023

If you are struggling to find out the possible causes and solutions of the error message AutoFilter method of Range Class Failed then this article is ...

[Fix]: AutoFilter Method of Range Class Failed (5 Solutions)

How to Autofilter and Copy Visible Rows with Excel VBA

Oct 2, 2023

You can easily apply the auto filter in Excel except using VBA code. But copying the filtered visible rows in the existing or a new working sheet is ...