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
Convert Formula to Relative or Absolute April 10, 2019
Convert Entire Excel Workbook to Values March 11, 2019
Evaluate with Excel to Extract Sequence March 6, 2019
Extract the First Item from a Horizontal List February 27, 2019
Create Number Sequence with VBA Custom Function January 15, 2019
Protect a Worksheet, Use the Autofilter October 18, 2018
Countifs Across Sheets October 10, 2018
Excel VBA to Select Sheets September 22, 2018
Power BI Desktop Dashboard August 20, 2018
New Excel Dashboard Tools August 1, 2018