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?