Click on a Cell and Contents of cell populate another cell in another worksheet

[brumby]

Hi There,

Hopefully an easy one.

I have a worksheet called "Main Sheet", I would like for any cell I click on in Col D, the contents of that cell to appear in worksheet "JOB CHECK" in Cell F1.


Appreciate you help as always!!!!

 

[ineedhelpido]

Put this script in sheet named

Options​

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'Modified  8/28/2018  10:57:21 AM  EDT
If Not Intersect(Target, Range("A:A")) Is Nothing Then
If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub
Cancel = True
Dim Lastrow As Long
Lastrow = Sheets("List").Cells(Rows.Count, "A").End(xlUp).Row + 1
Target.Copy Sheets("List").Cells(Lastrow, 1)
End If
End Sub

I know this was a while back - but any help would be amazing. How can I use this exact code BUT copy/paste values only? (No formulas/formatting etc). Thanks!

 

[ineedhelpido]

^NVM btw. Fluff's solution worked perfectly for my needs. Thank you Fluff and My Answer Is This. Very helpful thread!

 

[Fluff]

Glad it worked for you & thanks for letting us know.

 

[Msears]

Put this script in sheet named

Options​

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'Modified  8/28/2018  10:57:21 AM  EDT
If Not Intersect(Target, Range("A:A")) Is Nothing Then
If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub
Cancel = True
Dim Lastrow As Long
Lastrow = Sheets("List").Cells(Rows.Count, "A").End(xlUp).Row + 1
Target.Copy Sheets("List").Cells(Lastrow, 1)
End If
End Sub

I was wanting to know how to expand this code to do this: say on sheet 1 have have data in columns A and C, when double clicking a cell in A, I want it to populate A and C onto sheet 2 columns A and B, on the next empty row?

 

[Fluff]

Duplicate to: Click on a Cell and Contents of cell populate another cell in another worksheet

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.