#1
|
|||
|
|||
How to copy data to a specific cell by clicking on source cell?
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. |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
Thank you so much for your kind support. My big problem is resolved now.
|
#4
|
||||
|
||||
deleted (wrong thread)
Last edited by p45cal; 08-25-2021 at 04:52 AM. Reason: posted solution in the wrong thread |
Thread Tools | |
Display Modes | |
|
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 |