You could apply autofiltering to the document by selecting any cell within
your data range (so long as there are no completely blank columns or rows)
going to data filter Autofilter (In 2007, data tab and the filter
button).

Once autofiltering is applied, click on the quantity column's dropdown arrow
(located at the first row of data) and choose 'custom' then 'not equal to'
and input 0 (or in Excel 2007 just click the arrow then uncheck 0).

If you do have completely blank rows, consider Ron de Bruin's code examples
he

http://www.rondebruin.nl/delete.htm

to trim your data down.

"davo1805" wrote:

I want to create a sheet which will serve as a Proforma Invoice displaying
data from a Bill of Materials sheet within the same file. For any line item
where the qty is 0, I would like that row to be hidden so that the Invoice
bears only the line items relevant to the proposed supply.