Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-24-2021, 10:57 PM
LearnerExcel LearnerExcel is offline How to copy data to a specific cell by clicking on source cell? Windows 7 32bit How to copy data to a specific cell by clicking on source cell? Office 2013
Advanced Beginner
How to copy data to a specific cell by clicking on source cell?
 
Join Date: Nov 2016
Posts: 78
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default 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.
Reply With Quote
  #2  
Old 08-25-2021, 02:21 AM
p45cal p45cal is offline How to copy data to a specific cell by clicking on source cell? Windows 10 How to copy data to a specific cell by clicking on source cell? Office 2019
Expert
 
Join Date: Apr 2014
Posts: 514
p45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to behold
Default

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
File Type: xlsm msofficeforums47553.xlsm (13.3 KB, 2 views)
Reply With Quote
  #3  
Old 08-25-2021, 04:10 AM
LearnerExcel LearnerExcel is offline How to copy data to a specific cell by clicking on source cell? Windows 7 32bit How to copy data to a specific cell by clicking on source cell? Office 2013
Advanced Beginner
How to copy data to a specific cell by clicking on source cell?
 
Join Date: Nov 2016
Posts: 78
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default

Thank you so much for your kind support. My big problem is resolved now.
Reply With Quote
  #4  
Old 08-25-2021, 04:46 AM
p45cal p45cal is offline How to copy data to a specific cell by clicking on source cell? Windows 10 How to copy data to a specific cell by clicking on source cell? Office 2019
Expert
 
Join Date: Apr 2014
Posts: 514
p45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to behold
Default

deleted (wrong thread)

Last edited by p45cal; 08-25-2021 at 04:52 AM. Reason: posted solution in the wrong thread
Reply With Quote
Reply

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
How to copy data to a specific cell by clicking on source cell? 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
How to copy data to a specific cell by clicking on source cell? 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 12:33 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft