I need help figuring out how to double click a cell and have the value of another cell populate in the double-clicked cell. I have a macro that will do that in one cell but I can't figure out how to get the other cells to do the same. If cell G6 is double-clicked the text in C6 will copy to G6. Each cell will need to do this. If there is a better way please let me know! Thank you so much for your time!
The macro I have is:
Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Range("E3").Value = Range("C3").Value
End Sub
The macro I have is:
Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Range("E3").Value = Range("C3").Value
End Sub