Excel VBA Autofilter on Multiple Criteria
Anyone who has followed my posts on Ozgrid or Chandoo forum will have noticed how frequently I use the autofilter in favour of any kind of loop. I have been lead to believe that in some instances that arrays will perform faster than the humble autofilter however for brevity of code and swiftness I really like the simple elegance of the autofilter. In the article Autofilter on Multiple Conditions I delved into the world of the filer using more than one criteria.
Read MoreExcel VBA to Remove Data Which Does Not Match
In the article highlight column differences I touched on the VBA procedure:
The article was introductory where I did a bit of colour coding of cells which did not match and copied the non matching cells to a fresh sheet. Well this technique can be used in a multitude of ways. We can remove all of the rows in a sheet which do not meet criteria as specified in a particular cell.
For example if we had a listing of sales people we might want to isolate only a single sales person order quantity.
Read MoreFeatured Posts
Recent Posts
Split File into Parts and Save to Directory April 20, 2024
Most Popular Author December 14, 2023
Creating an Excel Dashboard - A Guide with Templates December 8, 2023
Real Estate Excel Dashboard October 11, 2023
Updating Excel Dashboards September 29, 2023
TheSmallman in Another Top Blog Rank April 24, 2023
Project Tracking Dashboard March 25, 2023
Excel Unique Formula September 17, 2022
Horizontal Range to Vertical Range in Excel June 15, 2022
Hiding Rows Quickly with VBA May 20, 2022