Printing a Summary sheet with only those lines with data

R

RTP

We maintain a Proposal Master in Excel. We would like to print a Summary page
which would include major categories, i.e. Software, Hardware, Interfaces,
3rd Party Software, and those lines under the major categories where the
quantity is NOT 0. Obviously, we have to keep all the lines in the Proposal
Master because some things are used by some clients and some by others. When
the quantity is changed to 1, or from 0, we would like to print all those
details by sub-category in a Summary Page.

Is there any easy way to do this???

Thanks for your help!!!
 
Top