Print rows based on criteria EXCEL

[salewit]

I am creating an Excel order sheet with hundreds of items. A customer will go in and enter what they want and then print the order out. I want to print out ONLY those rows where the customer specified a quantity. Is this possible?

i.e. Order Form in Excel:

Item Descr Price Qty
101 Widget1 10.00
102 Widget2 12.00 3
103 Widget3 14.00
etc, etc

When printed:

102 Widget2 12.00 3

 

[KenWright]

On quantity field - Data / Filter / Autofilter

Custom / Quantity > 0

Print

Regards
Ken..........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------