I have started a macro that may work. in order to make it work i have to link the checkboxes to a cell to spit out a true or false. i know this can be done soley in the code but i dont know how. the macro will get quite long the more check boxes you have. and a sections in the macro needs to be added for every checkbox/cobination of checkboxes. this should get you started if you need more help or guidance let me know.
Sub filter()
If Sheets("Sheet1").Range("A1").Value = True Then
ActiveSheet.ListObjects("Table5").Range.AutoFilter Field:=1, Criteria1:= _
"Apple"
If Sheets("Sheet1").Range("A2").Value = True Then
ActiveSheet.ListObjects("Table5").Range.AutoFilter Field:=1, Criteria1:= _
"Banana"
End If
If Sheets("Sheet1").Range("A1").Value = True And Sheets("Sheet1").Range("A2").Value = True Then
ActiveSheet.ListObjects("Table5").Range.AutoFilter Field:=1, Criteria1:= _
"=Apple", Operator:=xlOr, Criteria2:="=Banana"
End If
End If
End Sub
Bookmarks