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 ).

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
"But life is short and information endless;
nobody has time for everything" Aldous Huxley
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top