Quote Originally Posted by JBeaucaire View Post
Creating a macro to search for these patterns is pretty simple, but then what? The search is only half of the issue. So, describe what is supposed to occur with these matches? Create a new list? Hide all the rows that don't match? Delete them? What?
.

Thanks for taking the time to reply to this.

My situation is this.

1. I have very large sheets 500k rows of data with 16 columns that are supplied to me by a third party (so I have no control of how the data arrives).

2. I need to filter this data to match several criteria.
3. Once this data is filtered then I would like to send this data to a new "filter results" sheet.
4. Once in this "filter results" sheet I need to perform further manipulations on the data.

One issue I have is that the values in fields are not always consistent when representing the same thing. Meaning that one sheet will have a value of "Man" and another sheet "Manchester" both refering to the same thing. So if possible it would good if i could find a way of handling this.

I would welcome your comments.

once again thanks a lot for your help.