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

		Microsoft Office Forums > Microsoft Excel > Excel
How to copy data to a specific cell by clicking on source cell?

08-25-2021, 02:21 AM

p45cal

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

Office 2019

Expert

Join Date: Apr 2014

Posts: 962

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

Attached Files

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:10 PM.