Thread: Filtering Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael[_39_] Michael[_39_] is offline
external usenet poster
 
Posts: 1
Default Filtering Data

I would like to filter (not autofilter, the other one, is "Special
Filter" the exact name in english?) data in my excel Sheet, but it
just does not work...

Here my Problem:
I have a list with several columns, most of them include text. Then I
want filtering data, so that it only shows me the rows with the
following condition in a specific field:
[Content] < ''
[Content] < 'xyz'
-- the field must not be empty and must not contain the word 'xyz'...

How can I realize that?

A second problem is, that the output is static, means that it doesn't
change when the source changes. I think, I can solve this with vba.
Can somebody say the corresponding function?

Dou you know a good website or document with such information, i
rarely found some good stuff for vba/excel.

Ok... many questions, I know... Thanks for your trouble in advance.

Michael