Resource allocation plan

[sangeethajaikumar]

I have 100 resources to be allocated into 8 projects of varied duration. I want to have project allocations in one sheet and a summary of all the resources in another sheet. The summary must be auto-calculated. If any resource does not have an allocation in any month, then the summary should be highlighted. How do I create this view?

 

[pbornemeier]

There is not enough detail provided to answer that question.
What is the layout (what data is in each column) of each sheet?