Populate row of cells on one sheet depending on value in one cell on other sheet

[chilli76]

Hi guys

Can anyone help with the attached spreadsheet?

I want to populate "selections" sheet with data from the previous sheet (it will be the date) depending on the value of a cell in column G. You will see I have already got the data from 27th April into my selections sheet but wondered if it can be done by a formula to save me copy and paste time?

Many Thanks

[Special-K]

That will be fiddly with a formula as the number of matches varies for each day on your Selections spreadsheet.
If you have the dates in column A and the same number of matches per day that would simplify things.
As it stands now VBA would be your best solution.

[FDibbins]

What determine teh values in G? where do they come from and how do they get there?

This will pull what you want, based on the date you enter inA675. Copy across and down as far as needed
=INDEX(INDIRECT("'"&"*"&$A$675&"'!$A:$L"),MATCH(Selections!$G677,INDIRECT("'"&"*"&$A$675&"'!$G:$G"),0),COLUMN(A1))

For the next date, you will need to change the $A$675 reference