Autofilter Macro
Dear Stefi,
I'll try that. Thanks for your reply.
"Stefi" ...
One way is to use a helper column. Place strLong in a cell (in my example
G2), place formula
=ISNUMBER(SEARCH(F2,$G$2))
in first cell of the helper column (in my example F2), fill it down as
required, and Autofilter column F for TRUE.
Regards,
Stefi
?robot¡¨ ezt irta:
Hello,
I have a table with a column called "Source". This column can take on any
one of 50 values. I would like to use autofilter to filter out about 30
of
them. Is it possible with autofilter & VBA?
I am thinking about using VBA to concatinate the 20 admissible source
names
into one long string (strLong), then use it in an autofilter criterion on
the Source field. More specifically, I hope to find a criterion
specifying
that the field value is to be part of strLong. Unfortunately, criterion
such
as :="*<string*" works the other way round (ie it requires the field to
contain a certain string). So I got stuck.
Suggestions are most welcome! (I use Excel XP).
|