Previous Topic Next Topic

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 responses

Answer 1 / 4
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
Answer 2 / 4
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
Answer 3 / 4
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
Answer 4 / 4
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses