<div>
<div class="content wysiwyg-content">
I have a spreadsheet with 150 rows of data.<br />
<br />
I want to make another spreadsheet and couple each one of those rows 100 times one after another in the same order in the new spreadsheet. <br />
<br />
&nbsp;So in the new spreadhsheet there would 1500 rows total, 100same rows for each row in the original spreadhseet.<br />
<br />
Is there a vba that does that? &nbsp;thanks
</div>
</div>


I have a spreadsheet with 150 rows of data.

I want to make another spreadsheet and couple each one of those rows 100 times one after another in the same order in the new spreadsheet. 

 So in the new spreadhsheet there would 1500 rows total, 100same rows for each row in the original spreadhseet.

Is there a vba that does that?  thanks

EXCEL VBA 500 points!!

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.