Populate Cell from doubleclick

[bostonsm85]

I can't seem to figure this out and I am sure it is quite easy. I attached a sample workbook

I want to be able to click on any cell in column A of "Phone" sheet and be taken to "Introudction" sheet, simultaneously In introduction sheet I want F1 to be populated with the text from the selected cell from "Phone" sheet

Thank you in advance, I looked around for an answer but couldn't find one that I could modify and have work

[Richard Buttrey]

Hi and welcome to the forum.

One way - with a Sheet Selection change macro

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Not Intersect(Target, Range("A:A")) Is Nothing Then
        Sheet1.Range("F1") = Target.Cells(1, 2)
    End If
End Sub

[JOHN H. DAVIS]

See if this attachment does what you want.

[bostonsm85]

Perfect! Thank you both so much for the replies