How to set rules/criteria in a excel report

[Sf1802]

Hi all,
Currently I have an excel tracking file to keep track of the trainers’ availability for a list of scheduled programmes for the entire year. Based on their availability, I have to go through each programme one by one to match and see who to deploy. Typically for each programme I will need a team of 5-6 trainers. Also, there are a few criterias which I will run through, there needs to be a well mixed of females and males trainers, and some of the trainers are more suitable for certain type of programmes which I will deploy them first. In addition I will have to ensure that the programmes’ load is well spread among the trainers (at least 15 training days).

Hence I would like to check if there is a way for excel to do the first cut of allocation by availability, gender, suitability of the programme?

Hopefully someone can advice on this. Thank you!

 

[footoo]

Use AutoFilter ?

Sub NEI()
Dim x$, c%, y$
x = "Ijo›`ijpbc›diaj"
For c = 1 To Len(x)
    y = y & Chr(Asc(Mid(x, c, 1)) + 5)
Next
MsgBox y, 32
End Sub