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(B30,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