Macro to filter data base on combobox value

Status
Not open for further replies.

SSF1590

Board Regular
Joined
Oct 20, 2019
Messages
73
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.
 
Last edited:
Status
Not open for further replies.

Forum statistics

Threads
1,082,585
Messages
5,366,466
Members
400,892
Latest member
lamarh755

Some videos you may like

This Week's Hot Topics

Top