I found a solution myself. I suppose I limited answers by saying I couldn't change anything to make it easier. In the attendance sheet I made a new list offscreen with the students names in one column and the genders in the next column, then I sorted the cells based on the gender column so that the males were on top. Then in my seating chart sheet I put a formula that linked the first seat in the front row to the cell with the first name in the attendance sheet, then the second seat in the first row to the cell with the second name and so on. Depending on how many boys there are I could end up with a boy sitting next to a girl but I could manually just move one girl farther back very quickly. The formula in the first row of the seating chart would be something like this
where $BI$1 would have the first boys name
Bookmarks