Data arrangement macro

[makinmomb]

I want to re arrange my data as follows , if i do manually it will take long
, cell reference A meaning on sheet 2

D3	TO	A1
E3	TO	A2
J3	TO	A3
O3	TO	A4
N3	TO	A5
F3	TO	A6
G3	TO	A7
I3	TO	A8
H3	TO	A9
B3	TO	A10
K3	TO	A11
M3	TO	A12
C3	TO	A13
W3	TO	A14
U3	TO	A15
V3	TO	A16
S3	TO	A17
T3	TO	A18
X3	TO	A19
AA3	TO	A20
Y3	TO	A21

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[makinmomb]

No they are independent files

 

[makinmomb]

The macro will go into a blank file it will be called file3 ( macro file ) then it will go read the path of these files

c:\rickmagic\file1
c:\rickmagic\file2

File 2 will thus change , picking the data from the cells i have quoted to where
I want them

 

[Rick Rothstein]

The macro will go into a blank file , then it will go read the path of these files

c:\rickmagic\file1
c:\rickmagic\file2

File 2 will thus change , picking the data from the cells i have quoted to where
I want them

Are these Excel workbook files or text files?

 

[makinmomb]

excel , file1.xlsx

 

[makinmomb]

The most correct word for this macro would have been

File 1 data shift to File 2

 

[makinmomb]

I have purposely named the folder rickmagic as i know rick you can make this magic happen

Thank you in advance

 

[makinmomb]

Anyone else apart from Rick , maybe he is busy

 

[makinmomb]

I need this kind of urgent otherwise the data is huge ,
it is not worth doing this is manually for 100 trucks plus

 

[makinmomb]

Someone out there please save my day

 

[makinmomb]

It is beyond long to do this manually