Seating Plan

[ldoodle]

Hey,

I'm working on a seating plan for our christmas party this year.

Complete randomization of a list I can do, but I need conditions. We have 67 people, and 7 departments. I need seats 1-7 to be filled by 1 person from each department, then seats 8-14 to be the same and so on.

Ideally, adjacent seats would be boy-girl-boy-girl etc.

Each department has a different amount of people. There are 3 tables.

Sample attached. I don't expect to have it all done for me, so any pointers/guidance would be good enough. I've used INDEX with MATCH before but I can't quite work it of for this job.

EDIT: I've posted this elsewhere too: http://www.mrexcel.com/forum/excel-q...ml#post4678259

Thanks!