Hi,
Really hope someone can help with my query.
I need to create a dynamic report (that changes when the data changes) to reflect a staff member's project allocation over a period of time.
I've attached an excel spreadsheet showing what I am trying to achieve. I have created what I am trying to achieve manually but I have over 100 staff all on different projects and I don't want to have to manually create the report for each staff member.
For those who haven't opened the attachment:
I have multiple rows for each staff member based on the project they are on and I need to combine this into one row showing the person only once and the project they are working on in that month.
I'm not explaining this well but I've attached a screenshot of what I'm trying to achieve and also a sample excel file.
Happy to do this via VBA, a pivot or anything you suggest but this has me stumped.
Thanks in advance
\1
Bookmarks