Pulling info into another sheet
 

Hello,

I have a work sheet that looks like this:

19080 MISC, CT PUMP, 9V 2 D3B
Count 19091 DP-270 EPOXY 35 d3c
59009 MISC, CMDR BASE 3 D1D

I have another worksheet that I am trying to automate. I need to be able to
pull out the rows that have count in the first column. I only want the ones
that say count to show up. When I do an if statement or something like that.
It will pull those rows but then it also pulls all of the other rows and
leaves blank spaces. Does anyone know how to only get the count ones over to
the new sheet?

Thanks.
Teri