Skip printing specific Rows

[Erik Merk]

Hi,
Not an excel expert, but have a scenario where a company
has an invoice created in Excel with multiple categories.
However, we would like to create a Macro or use a function
that allows for Printing only the rows with an actual
quantity ordered (so the customer only sees rows
associated with the order rather than the entire price
list).

Any ideas or suggestions are appreciated.

 

[Andy B]

Hi

One way is to use Data / Autofilter on the table of prices and set the
filter to be on the Quantity column, set to greater than 0 (or non-blank)

 

[Juan Sanchez]

Erik

If hiding the rows that do not have data not an option
maybe you can Conditional Format the cells so that they
match the fore and background color if the quantity is 0
or blanck...

If you can hide then maybe you can use autofilter...
An other option is to create the Invoice as a Pivot
Table...

Cheers
Juan