How to copy data to a specific cell by clicking on source cell?

LearnerExcel · #1 08-24-2021, 10:57 PM

Hi,

I want to copy text from the cell which I click to a specific cell in the same sheet.

Ex: If I click on Cell E4 then It should be copied to Cell B4 , or If I click on E5 then also it should replace the data in Cell B4 (Cell B4 is constant here) and so on.

Thanks for any help.

p45cal · #2 08-25-2021, 02:21 AM

Not without VBA. Left-clicking difficult so this needs right-clicking.

See attached which has this code in Sheet1's code-module:

Code:

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
Range("B4").Value = Target.Value
End Sub

LearnerExcel · #3 08-25-2021, 04:10 AM

Thank you so much for your kind support. My big problem is resolved now.

p45cal · #4 08-25-2021, 04:46 AM

deleted (wrong thread)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I test a cell for a specific word if the cell has a drop down list.	RoehamptonTech	Excel	1	08-23-2017 05:05 AM
copy a cell from 1 file to another when data changes	jpreeshl	Excel	5	01-20-2016 09:06 AM
Trying to find a macro that will copy a cell and paste that value to a specific sheet	bryans88	Excel Programming	1	12-23-2015 01:40 PM
Copy matching data from one report cell to another cell report	mbesspiata	Excel	9	01-15-2015 01:49 PM
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1	bobznkazoo	Excel	2	03-27-2014 11:14 AM