Hey Everyone.
I downloaded an Advanced Filter Macro from Contextures.com (http://www.contextures.com/AdvFilterSearchWord.zip) and it works great.

I was wondering if anyone can help me set more criteria.

On the Worksheet it has the code

=AND(OR($B$1="",D7=$B$1),ISNUMBER(SEARCH($A$1,B7)))

On the VBA Worksheet Code Is This:

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Address = "$A$1" Or _
Target.Address = "B$1" Then _
Range("Database").AdvancedFilter _
Action:=xlFilterInPlace, _
CriteriaRange:=Range("Criteria"), Unique:=False
End If
End Sub




How can I add more Criterea to search more columns? Thanks Guys