I'm trying to populate columns G:AU on the "fixtures" with the corresponding fixtures found on the "fixtures rows" sheet.
I have manually entered the first 4 results (highlighted in yellow) to demonstrate. Every cell in every column should have a result.
E.G. on the 8th August 2015 the following fixtures took place
Chelsea v Swansea City
Manchester United v Tottenham Hotspur
Manchester City v West Bromwich Albion
Arsenal v West Ham United
This needs to be repeated for every row.....
all the fixtures with dates can be found on the fixtures rows sheet.
I can't find a quick way of doing this.
If someone can it would be great, please attach