Filter Problem

[Nimbo1842]

:banghead:Morning, I'm trying to find a way to filter a worksheet with one value on two different columns, but failing!

The below code works a treat to filter one column on the correct value

Worksheets("Update").Range("R1").AutoFilter _
field:=18, _
Criteria1:=FilteredOfficer.Value

I struggling to find a way to do it in two columns and unfortunately I'm using Excel 2003 (only until the end of the year).

Columns R and S are populated by officer1 or officer2, on each row the columns will never have duplicate values, however R5 might equal 2053 and S6 might equal 2053. With the code above I can filter R or S on their own to show all results equal to FilteredOfficer.value but can't find a way to do it for both!

Help

 

[Brianwarnock]

Don't apologise for using 2003 there is nothing wrong with it.

Does this do what you want

http://stackoverflow.com/questions/...cel-vba-to-filter-1-criteria-across-2-columns

Brian

 

[AlexHedley]

Sub FilterTo2Fields()
With Sheet1
            .AutoFilterMode = False
                With .Range("A1:D1")
                     .AutoFilter
                     .AutoFilter Field:=1, Criteria1:="Dave"
                     .AutoFilter Field:=4, Criteria1:="Lab"
                End With
    End With
End Sub

http://www.ozgrid.com/VBA/autofilter-vba-criteria.htm

 

[Nimbo1842]

Cheers Brian this has given me some interesting options