Tricky formula required

Dear clever ones,

Please can you help?

I have individual staff sheets that map allocation.  I have a front sheet which shows the allocation for each staff.

What I want to do now is make a front sheet which shows the allocation of resource Fte for each project.

There are 20 sheets each representative of a staff members fte

each sheet has the same row header.  Row 1 is mm,yy

In column A is the list of project that staff member is involved in.

1st I need to be able to cross match date and project name text and return that value.  Then I have to do that to combine all 20 sheets. 

Is this possible?  If so how?  

 

 

By: Sophie Hart

Leave a Reply

Your email address will not be published. Required fields are marked *