VB Code - loop a copy and paste a specified number of times

[santa12345]

Hello.
I have a simple worksheet for an example...

I want to populate R2:R6 with audi, then copy R7:R11 with benz, etc...
The real dataset I have in Column S is 100's of rows, but if I can get code using the above, I'll modify it as needed.
So copy Audi to column R..starting in R2 for a specified number of times, in this case, 5 times, then loop to do the same for the values in v3 - v6.. loop until done.


I can build out column S as needed... no need to have that in the code.
Hopefully this makes sense. If not - please let me know.
Thank you.

 

[Fluff]

How about

Sub santa()
   Dim Rng As Range, Cl As Range
   Dim NxtRw As Long
   
   NxtRw = 2
   Set Rng = Range("S2", Range("S" & Rows.Count).End(xlUp))
   For Each Cl In Range("V2", Range("V" & Rows.Count).End(xlUp))
      Cl.Copy Range("R" & NxtRw).Resize(Rng.Count)
      NxtRw = NxtRw + Rng.Count
   Next Cl
End Sub

 

[santa12345]

Hello and thank you for replying.
I'm getting the following error.

ON LINE the C1.copy Range line...

I did change the columns letters... as needed to fit my template.

 

[Fluff]

Can you please post the code you are using, an image dose not help. How to Post Your VBA Code

 

[santa12345]

Nevermind.. I have no clue what I'm doing.
The code you provided works great !!!
Thank you.. this will save me hours of copying and pasting data.
Thanks again and have a good day!

 

[Fluff]

You're welcome & thanks for the feedback.