Macro to filter data base on combobox value

[SSF1590]

Hello,

Would it be possible to have your help to change the below macro so it filters the data I have in worksheet "Data" in worksheet "DataFilter" based on combobox5 "Open", "Closed", "All". These three criteria are in column M in row 27 i my worksheet data.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$2" Then
If Range("B2") = "All" Then
Range("A5").AutoFilter
Else
Range("A8").AutoFilter Field:=2, Criteria1:=Range("B2")
End If
End If
End Sub

It does not matter if I have to have all my data in for example worksheet 1 and filter from there instead of having my data in a different worksheet than the one I want to filter. As long as I can filter based on those three criteria I mentioned above then it would be totally fine.

Thank you.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1114597-macro-filter-data-base-combobox-value.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).