Databases
StackOverflow2013
Postsdbo
POExcel VBA - how to efficiently copy multiple cells from one file to another?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POExcel VBA - how to efficiently copy multiple cells from one file to another?
    text
    copied!<p>currently, I am struggeling with the following: I have two Excel files. One files contains a lot of data, the other one is used to evaluate it. Now I need to efficiently copy data from the source to the target workbook. The source datapattern looks similar to the following:</p> <pre><code>x A B C D E F G H I 1 Oct bla bla bla bla bla bla bla bla 2 75 66 3 Nov bla bla IMT Frm bla bla IMT Frm </code></pre> <p>Where bla represents uninteresting data, Column A represents the Month (important) and IMT is important data, which is the cause of why I am doing this. Also, Frm means the cell contains a formula, rather than a value and has to be preserved/restored. Furthermore, the cell formatting of the target file has to be preserved (can be achieved with .PasteSpecial).</p> <p>The Target Workbook does look exactly the same, omitting the half emty row "2".</p> <p>Every row has about 10 valuable entries. How would I, most efficiently, be able to copy the data into the second workbook? Please let me know if there is more information which I could provide. Thank you for your time!</p> <p>EDIT: <a href="http://imageshack.us/f/208/excelw.jpg/" rel="nofollow">example screenshot</a> Clarification: The screenshot shows the source sheet. The important information is the one which is selected in the ss. The sheet goes on to the right like this (until BF). I need to copy every sixth entry. The target sheet looks exactly the same (omitting the half empty middle row), except for the needed information which, in the source, is a formula but it needs to be the value in the target. Thank you very much for helping me!</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload