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
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