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