auto filter

Guest · Jan 23, 2004

Good Morning - I have

A B C D E
1 23-32 dog 4/5 gh
2 1-456 cat 6/6 df
3 0 fish 2/2 d
4 677-3 elephant 8/8 f
5 0 lion 3/3 g

and I wish to filter out column B all that contain '0' and send newly filtered worksheet to another worksheet so that I have one worksheet with the rows '0' and another worksheet with all others.

I hope someone can help. It seems simple enough but after hours of trying I have only managed to make things dissapear! Thanks - Arthur

Jason Morin · Jan 23, 2004

For "0" records:

1. Select the entire range of data.
2. Data > Filter > AutoFilter
3. Select "0" in the drop-down list for column B.
4. Copy the rows and paste to a new sheet.

For non-"0" records:

1. While still in filter mode, select "Custom" in drop-
down list for column B.
2. Select "does not equal to" and then select 0.

HTH
Jason
Atlanta, GA

-----Original Message-----
Good Morning - I have:

A B C D E
1 23-32 dog 4/5 ghh
2 1-456 cat 6/6 df
3 0 fish 2/2 df
4 677-3 elephant 8/8 fd
5 0 lion 3/3 gh

and I wish to filter out column B all that contain '0'

and send newly filtered worksheet to another worksheet so
that I have one worksheet with the rows '0' and another
worksheet with all others.

I hope someone can help. It seems simple enough but

after hours of trying I have only managed to make things
dissapear! Thanks - Arthur

Guest · Jan 23, 2004

Hello,

Try the Advanced Filter, where you can copy the filter
result to another location.