Pete thanks for the tip. It did exactly what i wanted, although i was hoping
that it would shorten up my list instead of just hiding the contents of the
cells. is there any way to hide the entire rows that are not needed so that
my list shrinks?
--
Thanks,

Andrew


"Pete_UK" wrote:

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