Stock List 2

E

Eddie Wall

I would like to make a column for orders on a stock list.
Insert a quantity on that column for any of the items ( rows) I want
to order and then print it out... BUT I only want to print the rows
that have quantities in that column ( i.e. the actual items I am
ordering ).

Any ideas ?

Thanks


Eddie
"But life is short and information endless;
nobody has time for everything" Aldous Huxley
 
S

Scoops

I would like to make a column for orders on a stock list.
Insert a quantity on that column for any of the items ( rows) I want
to order and then print it out... BUT I only want to print the rows
that have quantities in that column ( i.e. the actual items I am
ordering ).
Click to expand...

Hi Eddie

Click Data > Filter > AutoFilter.

Click the drop down arrow on your quantity column and click
(NonBlanks).

Regards

Steve
 
E

Eddie Wall

Thank you Steve,.

Much appreciated.


Eddie





Hi Eddie

Click Data > Filter > AutoFilter.

Click the drop down arrow on your quantity column and click
(NonBlanks).

Regards

Steve
Click to expand...
"But life is short and information endless;
nobody has time for everything" Aldous Huxley
 
Top