Hi
Could someone possibly assist me, I am trying to achieve the following.
1. The information below is raw data that is pasted in and it will look exactly like the below.
2. I want the code to look down column A and split each race into its own sheet, rename the sheet and then remove the spaces between the times
3. The data is not static and under each race their may be various amounts of entries.
eg, of how i want the information to look on each sheet is below.
Appreciate any assistance with this.
Cheers
Could someone possibly assist me, I am trying to achieve the following.
1. The information below is raw data that is pasted in and it will look exactly like the below.
2. I want the code to look down column A and split each race into its own sheet, rename the sheet and then remove the spaces between the times
3. The data is not static and under each race their may be various amounts of entries.
eg, of how i want the information to look on each sheet is below.
Appreciate any assistance with this.
Cheers