Forum Discussion

jehane barbour's avatar
jehane barbour
Copper Contributor
Apr 20, 2018

Help with pushing some data from one cell to another?

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?

Formulas & Functions
Need Help
  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    Apr 20, 2018

    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

     

     

Resources