VBA code to copy specific cells in column from one workbook and paste to another

[Aimedija]

Hi,

Sorry if this question has already been asked but i think I do have a specific case.
I'm willing to copy data from column C to column O from a first workbook and past it to another workbook from column A to column M as below describe ;

Workbook named Doc1 and worksheet named Query (copy)[TABLE="width: 1040"]
[/TABLE]
[TABLE="width: 1040"]
[/TABLE]
[TABLE="width: 1040"]

<colgroup><col width="80" style="width: 60pt;" span="13">
<tbody>[TR]


[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column C[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column D[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column E[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column F[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column G[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column H[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column I[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column J[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column K[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column L[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column M[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column N[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column O[/TD]


[/TR]

</tbody>[/TABLE]
[TABLE="width: 1040"]
[/TABLE]
[TABLE="width: 1040"]
[/TABLE]
[TABLE="width: 1040"]
Workbook named Doc2 and worksheet named List2 (paste)

[/TABLE]
[TABLE="width: 1040"]

<colgroup><col width="80" style="width: 60pt;" span="13">
<tbody>[TR]


[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column A[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column B[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column C[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column D[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column E[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column F[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column G[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column H[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column I[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column J[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column K[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column L[/TD]

[TD="class: xl65, width: 80, bgcolor: #DAE7F5"]Column M[/TD]


[/TR]

</tbody>[/TABLE]
[TABLE="width: 1040"]

Thanks in advance
[/TABLE]
[TABLE="width: 1040"]
<colgroup><col width="80" style="width: 60pt;" span="13"></colgroup>
<tbody>[TR]


[/TR]


</tbody>[/TABLE]
[TABLE="width: 1040"]
[/TABLE]
[TABLE="width: 1040"]
[/TABLE]
[TABLE="width: 1040"]
[/TABLE]