I think the easiest way is to apply Autofilter to the quantity column
(or to a helper column which has a formula =quantity_cell) and select
Custom filter from the filter drop-down and then choose not equal to
and enter zero. This will hide all the rows with zero quantity, rather
than deleting them, so they are available for next time.

Hope this helps.

Pete

On Sep 21, 2:50*pm, AEHNLE wrote:
Hi, I work for a small construction company and I am working on a material
list for jobs. *What I need is a function that will go through the list and
remove any items that do not have a quantity in the row. *I would apprciate
any help that I can get.
--
Thanks,

Andrew