Copy cells automatically in MS excel

Solved/Closed
mahadevan1971 - Jun 11, 2009 at 06:50 AM
 mahadevan1971 - Jun 11, 2009 at 09:03 AM
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

mahadevan1971
Jun 11, 2009 at 08:31 AM
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
zaho14
Posts
14
Registration date
Sunday January 4, 2009
Status
Member
Last seen
June 16, 2009
11
Jun 11, 2009 at 08:22 AM
hye,

To do this you will have to drag and select the contents.... copy and paste where you want!
0
alex537
Posts
10
Registration date
Sunday January 4, 2009
Status
Member
Last seen
June 15, 2009
1
Jun 11, 2009 at 08:28 AM
This is the only way to do it!
0
mahadevan1971
Jun 11, 2009 at 09:03 AM
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
0