I have a list of projects which are either closed, active or pending. Closed projects have a date project was/is closed, active projects have a target date for closing. Each project is also categorized by type -- so lets say I have type1, type2 or type3 projects.
I have an assumption that each pending project, once activated will be closed in 6 months.

I have a list of people/resources who can have only certain number of project (4 at the most). And those people can take only certain type of (type1 or type2 or type3) projects.

So, I need to write a macro to do the following:
Figure out for each resource when will the close their projects and which project will they take on next and so on for all resources.

End goal is to figure out optimal resources and our projects closure rate.

Any help will be very appriciated.
Thanks,
Jay