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