Hi,

I have been told about Newsgroups and how they might be
able to help me with this problem.

I am organising a seminar for approx 150 staff. Staff
come from different Depts (Finance, Marketing, Personnel,
IT, Training); each member of staff has a Grade (1-5);
staff come from 1 of 4 locations (Area1, Area2, Area3 &
Area4); and there 74 female and 76 male staff. I need to
organise these staff into 6 Groups so that each Group
contains at least 20 and no more than 30 staff, and each
Group must contain at least 3 staff from each Dept,
Location, Grade & Sex.

At the moment I manually work it out but when staff cancel
or transfer it means that I have to re-jig the whole
format to ensure that my variables are correct. Is it
possible to automate a routine in Excel to help me manage
this - plenty of more cancellations are expected?

Grateful for any views and suggestions.

Fiona