VBA Code to filter Sheet2 data based on Shee1 Cell Value

[shaikhstonevilla]

Hi,

Thank you in advance.

Can you please help me with the VBA code so that when i enter value in Sheet1 A2 cell then Sheet 2 A1:P will automatically be filtered.


Thank you.

Shaikhstonevilla

 

[DanteAmor]

Put the following code in the events of your sheet1

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address(False, False) = "A2" Then
        If Target.Count > 1 Then Exit Sub
        Sheets("Sheet2").Range("A1").AutoFilter Field:=1, Criteria1:=Target.Value
    End If
End Sub

SHEET EVENT
Right click the tab of the sheet you want this to work, select view code & paste the code into the window that opens up.

 

[shaikhstonevilla]

Great. This is exactly what i was looking for. Thank you so much Bro.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.