When using Excel, how do I move data from one location (i.e. A1) to another (i.e C6)?

Question

I know I could copy and past and use the drag and drop tool but I have pages of data and thats would take forever. I just want to write in to excel that I want the data in this box moved to that box. Thanks

Answer 1

select the box you want it in, type =, then go back to the box that its in and select that. It should transfer the same info.

Answer 2

The = function could be placed at the top of the destination column and then dragged down the column and the rest would show, too.

Besides the = function, you could also record a MACRO to do the move. Depending on the reletive location of the data and where it will be moved to, the macro could be modified to fit your needs. If the data that is to me moved will be done over and over, it would look like this:

Sub Macro2()
'
' Macro2 Macro
' Macro recorded 7/19/2007 by Dan
'

'
Range("A2:B3").Select
Selection.Cut
Range("E2").Select
ActiveSheet.Paste
End Sub
~~~~~~~~~~~~~~~~~~~~~
GOOD luck

Answer 3

Cut all the data in one selection and paste it to the top left hand cell that you want it to go to. All the data will paste to that cell and to the right and bottom in the same format.

Answer 4

select the box you want it in, type =, then go back to the box that its in and select that. It should transfer the same info.

Answer 5

It can be done automatically with a macro.
Can't help with that. Maybe you can find a friend to build one.

Answer 6

cut and paste usually works