Yes. I am sorry. I sent the post before I typed the message.
Here is what I am trying to do.
I have maybe 30 or so worksheets. On each one there is information that may
or may not relate to each other. For instance, worksheet one has, Blue,
Green, Yellow, Orange. Worksheet two has Blue, Red. Worksheet three has Red,
Purple, Orange, Blue.
I want to delete, in this example, ever color listed throughout the entire
workbook without having to go through every page finding it and deleting it.
I would like to just make a list that has:
Red
Orange
Yellow
Green
Blue
Indigo
Violet
Anything that matches this list will be deleted in the workbook. (In my real
workbook I am not using colors.)
I appreciate any help. And again, I am sorry for the mistake on the original
post.
