I just watched a video on "Searchable Lists in Excel - Easy Method", copied the exact code the guy used, but however, while it runs perfectly for him, mine is not working. It says "Named Argument Not Found" whenever I try to run the search and highlights my first line of code, but I can not figure out what's wrong. (Also, on the file, I have not set up the Input or Field 2)
Sub SearchFi1ters()
Dim MainSheet As Worksheet
Dim MyTable As ListObject
Set MainSheet = Sheets("All WPS 3 or Less Processes")
Set MyTable = MainSheet.ListObjects("WPS_Table")
UserInput = MainSheet.Range("D3").Value
FieldName = MainSheet.Range("D5").Value
If UserInput <> "" Then
MyTable.AutoFilter.ShowAllData
If FieldName = "PQR" Then
MyTable.Range.AutoFilter Field:=2, Criteria:=UserInput
ElseIf FieldName = "Supported WPS" Then
MyTable.Range.AutoFilter Field:=3, Criteria:=UserInput
ElseIf FieldName = "Material 1" Then
MyTable.Range.AutoFilter Field:=7, Criteria:=UserInput
ElseIf FieldName = "Material 2" Then
MyTable.Range.AutoFilter Field:=12, Criteria:=UserInput
ElseIf FieldName = "Weld Wire 1" Then
MyTable.Range.AutoFilter Field:=22, Criteria:=UserInput
ElseIf FieldName = "Weld Wire 2" Then
MyTable.Range.AutoFilter Field:=31, Criteria:=UserInput
End If
End If
End Sub