Parsing Out Excel Data to a new Worksheet

OK, so I am starting to realize that what I am trying to do may be a bit over my head. I will describe it below and if anyone can help that would be great.

I have two worksheets "Gary Breakout" and "Macro List" in a workbook.

To help understand what I'm trying to do lets say "Gary Breakout" contains a list of names of students and there 100 meter sprint times. The students names are found in Column "C" There first 100m time is found in column "D" and there additional times are found in columns "F:S"

Some students have recorded up to 15 times, other students only 1 or 2. I am trying to create a macro the will copy the students name and there time(s) to a new worksheet. Of course there is the added issue of not all of them recording 15 different times, so some students will take up only 1 row in the new sheet, others 15.

In Column "B" I added a counta formula to count the number of times they have recorded a time "=COUNTA(E2:S2)"

With limited VBA knowledge I am trying to create a macro that will loop through all rows in "Gary Breakout" and based on the value in column "B" insert the appropriate number of rows into "Macro List" and copy the students name into column "A" of "Macro List" and there time(s) into column "B"

I hope this all make sense. If anyone can help it would be greatly appreciated.

Gentlemen, a tip of the day to keep things operating optimally. Whenever you declare a variable without a category, Excel defaults to the most expensive category of all, VARIANT. Mostly, I suppose that's fine, but as a general rule you want to qualify your variables to the least expensive and accurate category.

For loops, rows, columns, the safest choice is LONG as it only allows whole numbers and up to 2.4 million of them in Excel 2003, so plenty of room without teh expense of VARIANT. So declare them fully at the top like so:

Please Login or Register  to view this content.

========
OutThere, if that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

Also, be sure to fill out your profile so people will be able to see what version of Excel you're using without having to ask all the time.

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)