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 ).
Hi Eddie
Click Data > Filter > AutoFilter.
Click the drop down arrow on your quantity column and click
(NonBlanks).
Regards
Steve
Eddie Wall - 16 Feb 2007 19:34 GMT
Thank you Steve,.
Much appreciated.
Eddie
>> 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
[quoted text clipped - 12 lines]
>
>Steve
"But life is short and information endless;
nobody has time for everything" Aldous Huxley