Re: 123 print only rows with filled in column

Add a left-most column to your print range.
In it put the following formula and copy it down:

@IF([quantity]>0;"|";"")

[quantity] would reference the quantity cell for the row in question.
The symbol in the second argument of the IF function is the pipe symbol,
found on my keyboard just above the right-handed enter key.

Now include this new column in the range (set its column-width to 1) and
only the rows with amounts will print.


"Gary Spence" <whob4me@xxxxxxxxxxxxxx> wrote in message
news:nQq9f.2542$2y.2506@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Want to create a spread *** for grocery shopping which is no big problem
> but!
>
> How can I print only the rows that have an entry in the
> 'quantity to purchase' column?
>
> *** will have many products listed with a column to fill in for the
> quantity to purchase.
>
> Dont want to print all of the ***, just the rows with a quantity greater
> than zero or blank.
>
> Suspect I meed a macro but cant come up with the right idea.
>
> Thanks for any suggestions.
>
> Gary
>
>


.