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

Something along these lines should provide a way for you ..

Assume item nos are listed in A3 down,
quantities entered in B3 down, initials in C3 down

In D3:
=IF(B3="","",IF(B30,ROW(),""))
Leave D1:D2 blank

In E3:
=IF(ROWS($1:1)COUNT($D:$D),"",INDEX(A:A,SMALL($D: $D,ROWS($1:1))))

Copy E3 to G3. Select D3:G3, copy down to cover the max expected extent of
data in cols A to C. Hide away col D. Cols E to G will return the results you
seek, with all lines neatly bunched at the top. Adapt to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"AKSpring" wrote:
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