VBA and Macros: Microsoft® Excel® 2010

12. Data Mining with Advanced Filter

IN THIS CHAPTER

Replacing a Loop With AutoFilter

Advanced Filter Is Easier in VBA Than in Excel

Using Advanced Filter to Extract a Unique List of Values

Using Advanced Filter with Criteria Ranges

Using Filter in Place in Advanced Filter

The Real Workhorse: xlFilterCopy with All Records Rather than Unique Records Only

Using Filter in Place with Unique Records Only

Read this chapter.

This chapter was among the best chapters in the previous edition of this book. In the three years since that edition was released, I have discovered even more uses for Advanced Filter, AutoFilter, and even GoTo Special. In “Replacing a Loop With AutoFilter,” you will see a topic that I first discovered while researching the ...