[smpkge]

Here is my problem... I know there is a way to do what I am trying to do, but I am having a brain block.

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.

Export Page
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

2nd Page
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!!!!
Thanks,
Smpkge

[Advertisements]

Try the function "vlookup"


HTH
David

[dsm]

Try the function "vlookup"


HTH
David