Search : in
By :

Copy cells automatically in MS excel

Last answer on Jun 11, 2009 2:03:05 pm BST mahadevan1971, on Jun 11, 2009 11:50:03 am BST 
 Report this message to moderators

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?

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Copy cells automatically in MS excel » in :
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Excel - Send value of cell to target ShowExcel - Send value of cell to target Issue Solution Note Issue Is it possible to send the value of a cell (copy and paste special) to another cell where the value would not be disturbed when the source value changes to '0'? My...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Ask your question Reply

1

zaho14, on Jun 11, 2009 1:22:03 pm BST

Hye,

To do this you will have to drag and select the contents.... copy and paste where you want!

   
Reply to zaho14

2

alex537, on Jun 11, 2009 1:28:23 pm BST

This is the only way to do it!

   
Reply to alex537

3

mahadevan1971, on Jun 11, 2009 1:31:49 pm BST
  • +1

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

   
Reply to mahadevan1971

4

 mahadevan1971, on Jun 11, 2009 2:03:05 pm BST

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

   
Reply to mahadevan1971
Ask your question Reply
They need your help