Is there a macro I can use to remove data across the entire row depending
what has been typed in a popup msg box to ask "What would you like to keep?".
Have it
look at a column with such fields to filter.

Here I would want to only keep "color" and the remainder rows get deleted.

A B
black color
red color
blue color
yellow color
bat object
coat object
box object

Thanks in advance,

SimplyM