Finding very specific text in different places, and then displaying an entire reference

So I've got a large database of thousands of people and their personal information listed in the rows.

I need to find instances of specific characters and then display the full rows in a new list for any reference that contains those characters.

For example, if someone's name has "c.a.t." as a title at the start of it, I want to reprint that entire row of information into a new table (and every other person with an instance of "c.a.t." in their name) in a separate table from my current list of people.

So the two big challenges here are how to find instances of very specific text strings, and how to present the full rows of information that contain those specific bits of text in a new list.

Hi, jayon,

if the data is listed without any blank rows and columns within you could try and make use of the Advanced Filter. You need a row with headers for this. Copy that line to another sheet (maybe to Row 1) and regarding how many criteria you want maybe to Row 11 for the start of the data. Fill in your criteria under the header (no empty rows there - they would report every record). If you want to use more than one item to look at these items go under the same header in different rows (still no blanks).

Start the Advanced Filter from that sheet containing the criteria range, fill out the form (maybe give a name like Database to your list of records in advance), point to the criteria range, show where to put the data, copy to diffferent location. You could record that as a macro and use it - the range for the results will be cleared automatically when a new Filteriung is applied.

And yes, it can be done by VBA as well. Use the Find-Function and change the LokkAt-parameter from xlWhole to xlPart. Find will give a range-object if a match is found and that can be used to copy the data needed.

Ciao,
Holger