I have 1 worksheet page that is an export. The export contains numbers, names, address and specific contacts. On the 2nd worksheet is where I need the function.
If a row in my export contains a specific name, I want that entire row from the export sheet to copy over to the 2nd worksheet. So it would look something like this.
A B C D E F
1 Joe Smith 1234 Happy Lane Happyville USA Rachel
2 Andy Brown 2940 Smile Drive Smileville USA Rachel
3 Jane Doe 3920 Deer Court Deerfield USA John
4 Mary Johnson 324 32nd Street Anywhere USA John
If any of these rows contain the name Rachel, then I would like for the corresponding columns A-E to fill in on the second sheet.
I hope I made my question clear enough... I hope someone can help me fast!!!!