#1
|
|||
|
|||
How to paste the value of a selected cell to another sheet?
Hi, I want to copy data of any selected cell automatically and paste it in on another worksheet of the selected cell. How can I do that using VBA code? |
#2
|
|||
|
|||
Can you be a little more specific ?
Any time you click into, tab into or hit the enter key, the cell you go into becomes the selected cell, there are over 17 billion cells on each worksheet. How would VBA know which one(s) you want this copy to happen with, and how would VBA know what cell on which other sheet you want to paste to ? |
#3
|
|||
|
|||
Perhaps look into the Worksheet_SelectionChange and Worksheet_Change events.
|
#4
|
|||
|
|||
Quote:
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("A1:A9")) Is Nothing Then Target.Copy End If End Sub Note: It is working fine. My problem is resolved. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to copy excel sheet withe HEADER and Paste into new sheet? | cloudforgiven | Excel Programming | 6 | 01-05-2017 07:30 PM |
Open an existing sheet by clicking on a cell in a master sheet | darbybrown | Excel | 3 | 09-12-2016 05:12 PM |
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 |
Move data from one sheet to the next available row or cell of another sheet | bwwalker08 | Excel | 0 | 04-10-2015 11:51 AM |
Help Coloring a cell in Sheet one if data is missing from another sheet | Aeducan | Excel | 1 | 06-22-2014 04:49 PM |