I have a large list of items that need filtered using 2 criteria. I currently have:
q1 = sh2.Range("B11").Value
If q1 = "Y" Then
sh1.Range("A2").AutoFilter 10, "Y"
ElseIf q1 = "N" Then
sh1.Range("A2").AutoFilter 10, "N"
End If
What I need it to do is if cell B11 on sheet 1 is answered with "N" I need it to filter field 10 on sheet 2 with all the "N" and blank cells, if cell B11 on sheet 1 is answered with "Y" I need it to filter field 10 on sheet 2 with all the "Y" and blank cells.
Any help is appreciated as I am new to the vba world.
q1 = sh2.Range("B11").Value
If q1 = "Y" Then
sh1.Range("A2").AutoFilter 10, "Y"
ElseIf q1 = "N" Then
sh1.Range("A2").AutoFilter 10, "N"
End If
What I need it to do is if cell B11 on sheet 1 is answered with "N" I need it to filter field 10 on sheet 2 with all the "N" and blank cells, if cell B11 on sheet 1 is answered with "Y" I need it to filter field 10 on sheet 2 with all the "Y" and blank cells.
Any help is appreciated as I am new to the vba world.