Thanks Shaun seems ideal for what i want, however the problem is it seems to import extra horses for each race, for example caulfield race 1 it imported all the race 1 runners plus another 10 or 11 from somewhere else. Also if you could enable the sheet to be able to reproduce the formulas that i put in it to each new race sheet thta is produced if that is possible that is. Dont enough excel to know if that is possible. Thanks again for your efforts.