Hi,
I have a problem that I beleive can be solved via VBA programming...
Say we have candidates that have applied for entrance to a school.
An entrance examination is done and each candidate gets a total point as a
result.
Say we have 3 departments. DeptA, DeptB and DeptC in the school.
Each dept has a limit of points in order to apply and a max total capacity
of students.
On application Each candidate also supplies priorities for himself/herself
for the depts he/she applied.
Thus say we have a excel table like this:

Name Points 1stChoice 2ndChoice 3rdChoice
Jon 67 A B C
Martyn 70 A C B
Sue 65 B A C
Karen 78 C B A
Bush 66 A B C
John 78 C A B
Mac 89 B A C
Nancy 90 A C B
Mandy 56 C A B
Judy 89 A C B
Mag 86 B C A

Judy 77 C B A

and Limit Points for DeptA, deptB and DeptC are 70, 55 and 65 respectively
and Capacity for Depts A, DeptB and DeptC are 3, 4, and 4

How can we code excel to distribute these students to the depts so that the
above scenario will be satisfied?.
I will be happy glad if you can direct me to similar excel solutions to such
problems or provide a code that I can work on.
TIA
J_J