Issue to reposition to other cell RRS feed

  • Question

  • Hi,
    Code below is involved for the way to jump to relevant sheet when there is a click on cells of specific column. Can T column (of Manifiest sheet) be assigned with proper value based on the same row, when the code below is being triggered? See file here.

        If Not Intersect(Target, Union(Range(Cells(11, 20), Cells(lRw, 20)), Range(Cells(11, 27), Cells(lRw, 27)), Range(Cells(11, 28), Cells(lRw, 28)), Range(Cells(11, 38), Cells(lRw, 38)))) Is Nothing Then
            Application.Goto Sheets(Target.Value).Range("A1"), scroll:=True
        End If

    Many Thanks & Best Regards, Jackson Chen

    • Edited by Jackson_1990 Thursday, December 10, 2020 8:08 AM
    Thursday, December 10, 2020 7:39 AM