• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

Filter list by entry in another cell

I would like to filter a list based on a value in a specific cell. Can this be done? Thanks!!
Filter.xlsx
0
Euro5
Asked:
Euro5
1 Solution
 
nutschCommented:
Right click the tab
View Code
Copy the attached code in the worksheet module, you should be all set

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, [c1]) Is Nothing Then
        With [a12].CurrentRegion
            .AutoFilter
            .AutoFilter field:=1, Criteria1:=[c1]
        End With
    End If
End Sub

Open in new window


Thomas
0
 
Euro5Author Commented:
Thank you Thomas!! Very much appreciated!
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now