VBA row of data into several rows

[mrhoden]

G'day all,

I'm very new to vba and I was hoping somebody might be able to help me with some code for converting rows of racing data into a table. Each row has 6 columns of race info (A:F), then 8 columns of Horse #1 info (G:N), then 8 columns for Horse #2 (O:V) etc.

I would like Horse #2's info to be under Horse #1 (on the row below), then Horse #3 on the row below, and so on. I would still like each row to bring with it the race info from columns A:F. The issue is that each row has a different end point (due to the different number of horses in each race).

Sorry for the clumsy explanation. Any help on this task would be immensely appreciated.

Regards,

Marty

 

[wideboydixon]

It works just fine, until row 700, and i have 3000. Do you have any idea why ?

Oh. It should work through the whole file. Let me take another look at the code.

WBD