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.

Tags Excel, VB, ColumnDifferences, Remove