I currently have the follow macro
Sub Button16_Click()
Sheets("Detail Revenue").Visible = True
Sheets("Detail Revenue").Select
Worksheets("Detail Revenue").Range("C1").AutoFilter _
field:=3, _
Criteria1:="Cathy Fisher" _
Worksheets("Detail Revenue").Range("P1").AutoFilter _
field:=16, _
Criteria1:="Opportunity Closed/Won", _
VisibleDropDown:=False
End Sub
I need to be able to open one tab and filter by two columns using one macro command. But when I try the above I get a syntax error.
Any help is appreciated!
Sub Button16_Click()
Sheets("Detail Revenue").Visible = True
Sheets("Detail Revenue").Select
Worksheets("Detail Revenue").Range("C1").AutoFilter _
field:=3, _
Criteria1:="Cathy Fisher" _
Worksheets("Detail Revenue").Range("P1").AutoFilter _
field:=16, _
Criteria1:="Opportunity Closed/Won", _
VisibleDropDown:=False
End Sub
I need to be able to open one tab and filter by two columns using one macro command. But when I try the above I get a syntax error.
Any help is appreciated!