From a Data Range > DoubleClick on a cell to populate elsewhere

[KalliKay]

I have a large named data range that when one cell is double clicked on that
I would like the value from that cell to populate in a cell on another
worksheet. Is that possible? Thx.

KK

 

[Gary''s Student]

Put the following event macro in the worksheet code area:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Target.Copy Sheets("Sheet2").Range("A1")
Cancel = True
End Sub

It will take any cell double-clicked and copy the contents to Sheet2 cell A1.

Adjust to suit.