Search for Multiple Criteria and Return all Rows that Match.

I have a file where I can enter several criteria in B3 through B15 and then the macro will return all rows that match those particular criteria. However, I would like to know if there is a way to type several names in a single cell and search and return all rows corresponding to those names. For example, in B3 i would like to type Jane Smith, Brad Jones, John Doe and return all rows matching.
Again, thank you very much for your time and help.

Hi Kimston,
try it

Please Login or Register  to view this content.

it will work in Excel 2007, 2010 (2013?)

Thank you Nilem for your quick response. I am having some problems running this macro in MS 2003. It says "Compile error: Variable not defined". and it highlights

Please Login or Register  to view this content.

.
I wonder if it has to do with the MS 2003 version.

Kim,

You can search Multiple criteria by using an array or a split funtion
For e.g if you have the words you wish to search are in Range D3, separated by a comma, you can use this function

words to search = Split(Range("D3"), "'")

AB33,
Thank you very much for your response. However, I don't quite understand how split function works, and I tried to used your function =Split(Range("D3"), ""), but it doesn't doe anything. Can ypu provide an example using the provided excel file?
Thank you