Filter VBA Offset function

[p4nny]

Hello

I currently have the code however I would like to change it slightly.

The line with '''''

Rather than the code perform this action "testCell.Offset(, 1).Value = "Key in the dependency ID"

I would like it to filter another tab called "dependencies" (column A) by using the value in the original tab (Offset(, -2)

Then stop the code on the "dependencies" tab.

So when testCell.Value = "Y" Then filter "dependencies" tab for the value in (Offset(, -2)

Hope that makes sense.

Private Sub Worksheet_Change(ByVal Target As Range)


Dim testRange As Range


Set testRange = Application.Intersect(Target, Range("C:C"))


If Not testRange Is Nothing Then
    Application.EnableEvents = False
    For Each testCell In testRange
        If testCell.Value = "Y" Then
            ''''''testCell.Offset(, 1).Value = "Key in the dependency ID"
        Else
            testCell.Offset(, 1).Value = "N/A"
        End If
    Next testCell
    Application.EnableEvents = True
End If


End Sub