Hi to everyone!

I am doing a rota for school and have down a form which has
Day Student Name | House |Male/Female
Monday
Tues
Wed
Thurs
Fri

the data is from excel
A B C D E F
Surname Forename Gender House Year Reg
Jones Alexia F Austen Year 7 ABAK

AND is repeated in Columns H to M but for Males

I need to have a Female on a monday, then a Male on a tues etc throughout the school term approx 6 weeks

I have tried next record if but does not work, any pointers would be greatly appreciated

cheers / Paul