There are plenty of tricks you could do to get fixed. Here is one:
Go to your home tab
Go to conditional formatting
Highlight text that contains (enter the word you want)
Filter and sort
Custom Sort
Sort on cell color
Save your macro
Then all you have to do is delete the rows manually each time.
|