Stock List 2

  • Thread starter Thread starter Eddie Wall
  • Start date Start date
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
 
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
 
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
 

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

Similar Threads

Stock list 2
Adding and subtracting from a column. 6
SUM - IF - AND 7
Radeon 6970 on 3 monitors- Problems 0
Count multiple rows with vlookup 3
is this possible in excel 2007 3
Access Stock In Hand query in access 2007 0
"Print This Page" Macro 3

Back
Top