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 sele...
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