Excel 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
XLookup to the Party August 31, 2019
Populate a Userform with VBA August 14, 2019
New Dashboard Ideas August 9, 2019
Excel Custom Sort August 7, 2019
Excel VBA Remove Duplicates Multiple Columns August 6, 2019
The Tennis Chart July 17, 2019
Smallman Interview July 15, 2019
Excel Summit South 2019 July 12, 2019
Sales Excel Dashboard June 14, 2019
Using the Wildcard with SUMPRODUCT May 30, 2019