Sheet1 contains a list of course codes and the dates the courses are running
eg.
CSB00 09-Jan-2006
CSB00 10-Jan-2006
CSB01 09-Jan-2006
CSB02 10-Jan-2006

Sheet2 contains a list of students and the courses assigned to the students
eg.
James CSB00 Dep1
Jones CSB00 Dept1
Sam CSB00 Dept2
John CSB00 Dept2
(Data in different cells for name, course, Dept)
Please a macro or VB to assign students (max say 2 per course date) to
course dates and distribute across department ie one fron Dept1 and the other
from Dept2. Please make it as general as possible as I wish to apply to a
large database

Thanks in advance
--
JA