Material List

  • Thread starter Thread starter AEHNLE
  • Start date Start date
A

AEHNLE

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.
 
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
 
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 said:
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
Click to expand...
 
Well, that's how the filter works - it hides a complete row if the
cell in that row doesn't match the criteria that you have set in the
filter drop-down, so all those rows with a quantity of zero should be
hidden.

Are you using multiple rows for one record?

Pete
 
Back
Top