Help with pushing some data from one cell to another?

[jehane barbour]

Hi,

I'm looking for some help with pushing some data from one cell to another. What I want to do is select a particular cell and send the parameter with the cell value to a different sheet. The selected cell will also have a hyperlink to the cell in the different sheet.

So that when I select the value in the first cell in the first sheet using a dropdown list, that selection will be sent to the cell in the second sheet.

I've uploaded a test file with the example. 

How can I do this without using VBA or Macros? Is it possible?

[#2]

I don't think this is possible without macros.  You can definitely have a dropdown in Sheet1 and when this dropdown changes the value will populate on Sheet2.  However, based on your example I think you wish to select a data row on sheet 1 and have it populate on sheet 2.  Looks like you want something that will populate the row of data in a type of form....

This simple code will do want you want: on a double click: 

Paste this VBA code in the Sheet1 Code Module:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

    Sheet2.Range("B1") = Sheet1.Range("A" & Target.Row)
    Sheet2.Range("B2") = Sheet1.Range("B" & Target.Row)
    Sheet2.Range("D1") = Sheet1.Range("C" & Target.Row)
    Sheet2.Range("D2") = Sheet1.Range("D" & Target.Row)
    Sheet2.Activate

End Sub

[#3]

Hi

just tried the your requirement. Go through the attached file.