Use VLOOKUP in the form =VLOOKUP(A2,Sheet1!H2:M1000,2, false)
and =VLOOKUP(A2,Sheet1!H2:M1000,3, false) etc
Then use Data | Filter |Auto Filter with a custom filter of: Not Equal to
#N/A

I am assuming the data on sheet 1 begins in H and continues to the right
If this is not the case, we need a Match and Index combo - let me know how
Sheet1 is set out
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"bbrant2" wrote in message
...
I am trying to get information from one sheet to another. On sheet 1 I
have
a list of various names in Column H. I would like for sheet 2 to gather
the
row of information if the name in sheet 1 column H is equal to sheet 2 A2.
But i don't want blank rows (or ones that don't match) to come across on
sheet 2.
Can any one help with this?