Office supply/order form

[AKSpring]

I created a list of office supplies in Excel that my office regularly use.
What I would like is for the employee to open the worksheet, enter the
quantity of the supply requested and their inititals. The information they
enter is copied to a hidden worksheet that I will use to place the supply
order. I'm using the If function: if "qty" greater than zero, enter "item
no." =IF(B3>0,A3,""). The problem I'm having is the empty rows that are there
inbetween the items selected to order. Is there a function to use so the rows
that report zero not appear in my hidden worksheet?

Thank you.

 

[Gordon]

I created a list of office supplies in Excel that my office regularly use.
What I would like is for the employee to open the worksheet, enter the
quantity of the supply requested and their inititals. The information they
enter is copied to a hidden worksheet that I will use to place the supply
order. I'm using the If function: if "qty" greater than zero, enter "item
no." =IF(B3>0,A3,""). The problem I'm having is the empty rows that are
there
inbetween the items selected to order. Is there a function to use so the
rows
that report zero not appear in my hidden worksheet?

Thank you.

Why not just set a filter on the hidden sheet to show rows that are greater
then zero?