Hi everyone!

I am really desperately in need of help from you excel gurus. Have been searching through the web/forums for a solution but it has been in vain.

I have basically new tasks everyday up to around 100. I have a list of employees, example 20. However they have different skill sets. I would like to allocate them with tasks equally and according to their skills set.

Attached is the sample excel ( the raw data as well as my intended outcome ).

Greatly appreciate the help from you guys! It can be either using vba or formulas

sample book.xlsx