Filters

[normaalicia]

Hello I am Norma.
What filter should I use, if I want more than two conditions or if I want to analyze the list using database function?

I appreciate all of your help. Thank you in advance.:yes

[Logit]

Here is one example of a Two Field Filter :



Option Explicit


Sub FiltrDateJob()
Dim ans1 As String
Dim ans2 As String


ans1 = InputBox("Day Of Month ?", "Job Search")
ans2 = InputBox("Job Number ?", "Job Search")


Worksheets("Sheet1").Range("B1:AF1").AutoFilter Field:=ans1, Criteria1:=ans2
End Sub


Sub clrFil()
Sheet1.ShowAllData
End Sub




But your project may require something different ...