For each X, repeat Y times

[Tycho_vk]

Hi Guys!

I have been searching and searching, and maybe I'm using the wrong keywords. Anyway, what I want to do (which isn't getting me far atm):

I'm organising an event, and I want to give nameplates (like badges) to everyone with their name on it. So I got a list of people who are coming in excel (one column with first names, one column with surnames).

So what I want to do, is make excel put those two together in one (new) field, and add a field below that with the name of the event. And do that for each of the first name + surname rows.

For testing, I'm trying something out, but no luck so far . See image. For some reason, when I try to copy the formula down, it does not continue where it stopped. Either way, this does not seem to be the most optimal way to do this.

Can anyone help me?
Thanks in advance!
Greets,
Tycho

 

[JackDanIce]

Welcome to the board.

Not sure I follow your problem, but based on the screenshots, try this macro:

Sub InvasionOfCarrots ()
Dim i as Long, j as Long
Application.ScreenUpdating = False
j = 1
For i = 1 to Range("F" & Rows.Count).End(xlup).Row
  Range("I" & j) = Range("F" & i)
  j = j + 2
Next i
Application.ScreenUpdating = True
End Sub

 

[Tycho_vk]

JackDanIce, thank you for your amazingly fast and informative answer. I've already learned a lot, and I'm going to try to figure out the rest as well .

 

[JackDanIce]

You're welcome