View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TooN TooN is offline
external usenet poster
 
Posts: 35
Default Custom filtering has only two entries (and, or)? Ive got at least

Hello,

Ive got a problem with filtering. Ive got a sheet with at least 20 columns
and about 1000 rows. In column D there are all different activitys. I shall
give you an example what column D looks like:
0005
0005
0006
0006
0007
0007
0008
0008
0008
0008
0009
0009
0011
0011
0012
0012
0020
002B
002B
002B
002B
0030
003C
003C
0040
0050
005A
005A
0025
004C
004C
etc. etc.

When i want one or two activities its not a problem, i can use the filter
option and than go to custom. The problem is that i always need more than 2
activities.

Is it possible to create a macro that allows me to enter as much activities
as i want. After entering these activities (maybe in a popup??) Column D
shows these activities and ofcourse the whole line...

Please help me with this, its killing me!!!!

Thanks