copying data from multiple columns to a single column on different sheet

Excel Form Help.xlsx

Hello I need help please. I'm a novice and don't really work with Excel VBA on daily basis.

Basically this is for a summer camp. Parents register their kids and all that gets saved to a worksheet. Parents can register multiple kids at one time but if they do that the data doesnt get saved in Columns for each individual kid. You will see from the spreadsheet I attached.

As you can see if a parent registered more than one kid the data for the kid is saved in the row for each submission. The next submission does though get saved in the next row down but again if more than one kid is registered the data gets spread out that row.

So what i want to do is take the info from Sheet1 for each individual kid and move it to Sheet2 the columns I will have are (First Name Last Name Birth Date Age Gender 1st Time? Swim? Tshirt Size Health Medication Allegies Disorder Type of Disorder? Additional Info).

Please look at the attachment, it will make sense.

Also, how could i loop through data in row1 and then when nothing is left, loop through row2, etc.

And also since parents will continue to register the kids, I will continue to get new submissions, so I'd like to be able to somehow look at the submission date to make sure when i run the macro so previous submissions arent copied.

I really dont even know how to begin to approach this. so any advise and help and examples of how to do this will be much appreciated

try

Please Login or Register  to view this content.

Thank you that worked perfectly. much appreciated!