Creating a requisition in one sheet from another sheet...

[BGD]

As the title states I'm trying to create a material requisition. I have three columns on the first sheet; Part Number, Description, and Order Qty. I have 1674 rows of part numbers and descriptions. I want the user to be able to enter the order quantity needed on the first sheet and that information, along with the part number and description, should then be copied to the second page without all of the rows that have no quantities being copied. To simplify what I'm trying to say, I want Excel to copy all information in ONLY the rows that have an order quantity. Is there code for this that will not freeze the program since there are so many rows of data?

[Marc L]

Can be done with an advanced filter without or with code …

[BGD]

Either I just don't know how to us it or the advanced filter is not working for what I need. Thanks for the suggestion though.