EXCEL VBA 500 points!!

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
LVL 10
GlobaLevelProgrammerAsked:
Who is Participating?
 
ZekeLAConnect With a Mentor Commented:
I suggest you just turn on macro recording, do the copy and paste a few times and then build your vba from that. I just tried it with a new spread sheet and got this as a start:

    Rows("1:8").Select
    Selection.Copy
    Range("A9").Select
    ActiveSheet.Paste
    Selection.End(xlDown).Select
    Range("A17").Select
    ActiveSheet.Paste
    Selection.End(xlDown).Select
    Range("A25").Select
    ActiveSheet.Paste
    Selection.End(xlDown).Select
    Range("A33").Select
    ActiveSheet.Paste

Basically, select the data you want to copy. Find the end of the data so far, go one more row and paste the selection there. Then just repeat the process of Find End and Past (no need to reselect the data to copy, it's still selected.)
0
 
GlobaLevelProgrammerAuthor Commented:
Awesome!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.