macro to split up a row of data, while repeating first columns

[collirde]

Hello, I am trying to collect data for my school from all the teachers. They are currently collecting data using Google form and they are having to submit a form for every student. I was hoping to try and have a form that would allow the teacher to input their data, that is constant, and then all the different students. I think this will create a google response sheet that looks something like the sample. What I want is to be able to run a macro that would keep the teacher name, class and bell and then take the next 3 columns and make new rows, depending on how many students each teacher enters. I included one where the first section of students was blank, in case a teacher typed the info in the wrong section. Any help would be appreciated.

Book1.xlsx

So basically when i collect the data it comes in like this:
Teacher -- Class -- Bell -- Student Name -- ID -- Absences -- Student Name -- ID -- Absences --Student Name -- ID -- Absences --Student Name -- ID -- Absences

But I want it to break off the extra student info and make just the first 6 columns.
I'm still trying to figure out exactly how to get the google form to work correctly, but I figured this part was the most pressing and challenging.

[walruseggman]

Creates a new sheet for you every time it runs called "New Format" plus a number. Also assumes your raw data is on a sheet called "Sheet1". If not, change the first line of code to match your sheet name.

Please Login or Register  to view this content.

[collirde]

This seems to work perfectly. Just a quick question... Is there any chance you could give some explanation as to what each part of the code is doing, so that if I need to change it later to adapt to new situation, I would hopefully be able to fix it without bothering all you incredibly smart people. Thanks.

Ray

[walruseggman]

Please Login or Register  to view this content.

[collirde]

You are awesome, thanks for your help. I hopefully can make this all work and not have to bother you any more.

[walruseggman]

Glad to help. If you do have more questions, that's fine, but if you're satisfied with the solution for now, please mark this thread as SOLVED. And any reputation points (the * in the lower left of the posts) is appreciated.