software

I'm trying to get an advanced filter to work so that it will bring back
all records with part of the word rather than just the start of a word.
This works very well when I use AutoFilter with the quot;Containsquot; criteria.
But when I do an advanced filter, only records that start with the word
get filtered. What do I have to do to get all the records. Thanks...

Try something like this:

If Col_A, beginning at A1, contains the text values, has a heading of
MyText, and you want to find records where Col_A contains the word quot;turtlequot;:

The criteria range could be:

C1: MyText
C2: *turtle*

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Sierrasquot; wrote:

gt; I'm trying to get an advanced filter to work so that it will bring back
gt; all records with part of the word rather than just the start of a word.
gt; This works very well when I use AutoFilter with the quot;Containsquot; criteria.
gt; But when I do an advanced filter, only records that start with the word
gt; get filtered. What do I have to do to get all the records. Thanks...
gt;

Wrap the criterion that you use inside two * wildcards.

Sierras wrote:
gt; I'm trying to get an advanced filter to work so that it will bring back
gt; all records with part of the word rather than just the start of a word.
gt; This works very well when I use AutoFilter with the quot;Containsquot;
gt; criteria. But when I do an advanced filter, only records that start
gt; with the word get filtered. What do I have to do to get all the
gt; records. Thanks...

I have something like this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count gt; 1 Then Exit Sub
If Target.Address = quot;$A$2quot; Or _
Target.Address = quot;$B$2quot; Then
Range(quot;Databasequot;).AdvancedFilter _
Action:=xlFilterInPlace, _
Unique:=False
End If
End Sub

This is code when you right click the tab. I tried putting quot;*quot; in various
places in this code but can't get it to work. The only way is to put a
quot;*quot; before any word I'd like to search for. This works, but I'd like to
be able have it do it automatically so that I just have to type the word
I'm looking for without any quot;*quot;'s.

Thanks..On Wed, 08 Mar 2006 14:21:49 -0500, Aladin Akyurek gt;
wrote:

gt; Wrap the criterion that you use inside two * wildcards.
gt;
gt; Sierras wrote:
gt;gt; I'm trying to get an advanced filter to work so that it will bring
gt;gt; back all records with part of the word rather than just the start of a
gt;gt; word. This works very well when I use AutoFilter with the quot;Containsquot;
gt;gt; criteria. But when I do an advanced filter, only records that start
gt;gt; with the word get filtered. What do I have to do to get all the
gt;gt; records. Thanks...
--
Using Opera's revolutionary e-mail client: www.opera.com/mail/