Attched is a work book.
Sheet1 shows a list of horse races with stats that i pull from the internet - at the moment i have to go through manualy to make my selctions but i would like to have this process automatic.
I would like it so when i copy and paste the data into sheet1 sheet to can read the data from sheet one and make it neat!!!
Basicly i need to strip out the 'junk' and put it together shown in tab2. I have also added an extra colum 'Race Num' this will need to have the race number in so race 1,2,3,4,5 ect.
The issue is each selection will be different depending on the number of horses in the race BUT it will always begin with the header titles for each race "No. Form Days Horse Age Weight Headgear Jockey Trainer OR FC Odds HRB Total CD Form
" and will and with a blank column then "Last Years Winner" .
Hopefuly i have given enough information to hopefully get an answer to how this can be done.