How to match data patterns across multiple columns

Originally Posted by JBeaucaire

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.

Great ,thanks a lot for this.

Could you tell me how i could take this one step further and filter perform the filter if i only know part of the filter string ?. For example if i want to filter the word "manchester" but the word in my original document is noted as "man" and "manchester"

Originally Posted by martindwilson

you can use wild cards on data see here
http://www.contextures.com/xladvfilter01.html
also
3. Once this data is filtered then I would like to send this data to a new "filter results" sheet.
you canjust coppy the rows and pase
or select copy to another location this would have to be on the same sheet tho' just chose somwhere not in the range of your data then copy it to a new sheet

Excellent , thanks a lot Martin.