Copy cells automatically in MS excel

[Solved/Closed]
Report
-
 mahadevan1971 -
Hello,
I have an excel sheet full of data .Typically 10 or more cells in a row. I want to copy contents of each cell by simply moving the arrow key over each cell.can you suggest a simple solution for this requirement?

4 replies


Hello sir
I want to copy contents of each cell by simply moving the arrow key over each cell.
I need a workable macro or a tool for this task
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
14
Registration date
Sunday January 4, 2009
Status
Member
Last seen
June 16, 2009
11
hye,

To do this you will have to drag and select the contents.... copy and paste where you want!
Posts
10
Registration date
Sunday January 4, 2009
Status
Member
Last seen
June 15, 2009
1
This is the only way to do it!

Hai

I tried this code in excel macro :
Sub Copy()
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target.Copy
End Sub

But it says that "Expecting End Sub"

The code is not working

Please tell me a way to solve this problem

Regards
M S Mahadevan