Advanced Filter "to filter search (3) Deff Columns?

[tazmtiger]

Hi!

Does anyone here know how to go about filtering criteria based on three different columns, using xlFilterCopy from one worksheet to another?

I am using the code below now for 1 filter criteria, works great, but I need to filter 2 other additional columns... Does any one know how to mod this code to make this happen??

Your help will be appreciated.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 2 And Target.Column = 2 Then
Sheets("Parts Entry").Range("Criteria").Calculate
Worksheets("Parts Entry").Range("Database") _
.AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Sheets("Parts Entry").Range("Criteria"), _
CopyToRange:=Range("A6:K6"), Unique:=False
Sheets("Part Search").Range("B3").Calculate
End If
End Sub

Thank you in advance!

 

[Andrew Poulsom]

You just need to expand your criteria range so that it has 3 colums of criteria.

 

[tazmtiger]

You just need to expand your criteria range so that it has 3 colums of criteria.

Unfortunately; I am not that talented, How do I go about to accomplish that?

If you could be so kind as to help me with an illustration, I would appreciate it very much.

Thank you!

 

[Andrew Poulsom]

Look here:

http://office.microsoft.com/en-us/excel-help/filter-by-using-advanced-criteria-HP005200178.aspx