I am new to Excel and was wondering how to perform the simple move.

I have products on sheet2. About 25 of them in the format of

Product Name1, Price, Quantity
Product Name2, Price, Quantity
........
ProductName25, Price, Quantity

The Product Names are filled in and the price is filled in. What I would
like to do is enter a quantity if I want the product. Once I finish
entering in quantities, when i click on Sheet1, I would like the rows that
have a Quantity to be placed on Sheet 1.

How can I do this?

Thanks,

Gary