Thanks for the help

On sheet one I have a list of items I inventory.  The list is by vendor and
I cannot use a sort because I would lose vendor order.  Below is an example
of the data I work with.

I would like to draw out onto sheet two the data that has a count only.  For
example, below the line that has 44, 50, 101, 120 and a couple 0’s.  The only
data I would like to show on sheet two are the rows that have 44, 50, 101 and
120.

Vendor Name
627298    4.5ft Stainless Steel    Inventory    44    $15.75    $693.00
627304    5.25ft Stainless Steel    Inventory    50    $20.25    $1,012.50
627311    Copper Coated    Inventory    101    $14.50    $1,464.50
627328    Silver Coated    Inventory    120    $14.50    $1,740.00
21-0362    Swirl Bistro Table    Inventory    0    $500.00    $0.00
21-0162    Swirl Dining Armchair    Inventory    0    $500.00    $0.00

Another question I have is once the data is pulled over to sheet two, is
there an easy process for removing the empty rows so the data shows without
lines, or like the following:

Vendor Name
627298    4.5ft Stainless Steel    Inventory    44    $15.75    $693.00
627304    5.25ft Stainless Steel    Inventory    50    $20.25    $1,012.50
627311    Copper Coated    Inventory    101    $14.50    $1,464.50
627328    Silver Coated    Inventory    120    $14.50    $1,740.00

Thanks