<div>
The process has to be repeat 500 times single cell to merged
</div>


The process has to be repeat 500 times single cell to merged

<div>
Part 2 to above question <a href="https://www.experts-exchange.com/questions/28146829/copy-data-from-single-cell-into-merged-different-wkbs-part-2.html" rel="ugc">https://www.experts-exchange.com/questions/28146829/copy-data-from-single-cell-into-merged-different-wkbs-part-2.html</a>
</div>


Part 2 to above question https://www.experts-exchange.com/questions/28146829/copy-data-from-single-cell-into-merged-different-wkbs-part-2.html [https://www.experts-exchange.com/questions/28146829/copy-data-from-single-cell-into-merged-different-wkbs-part-2.html]

<div>
<div class="content wysiwyg-content">
Hi experts<br />
<br />
how would you copy data in workbook 1, worksheet 1 cell a2 into workbook 2 worksheet 1 merged cells a2:a10 and then cell a3 wkb1 into merged cells a11:a19 wkb2...
</div>
</div>


Hi experts

how would you copy data in workbook 1, worksheet 1 cell a2 into workbook 2 worksheet 1 merged cells a2:a10 and then cell a3 wkb1 into merged cells a11:a19 wkb2...

copy data from single cell into merged different wkbs

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.