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

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.

Do you want to remove the rows, or hide them?

http://www.contextures.com/xlautofilter01.html

Hide them, sorry for the confusion
--
Thanks,

Andrew


"Glenn" wrote:

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.

Do you want to remove the rows, or hide them?

http://www.contextures.com/xlautofilter01.html

Hi,
take a look at CPearson web, go to the middle of the page

http://www.cpearson.com/excel/deleting.htm

if this helps please click yes thanks

"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

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

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

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

On Sep 21, 3:58*pm, AEHNLE wrote:
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- Hide quoted text -

- Show quoted text -