Hi,
I have created 10 separate worksheet for project managers to manage staff resourcing.
However, now I need to feed back all this information into a MASTER Workload sheet in a separate workbook which will allow management to discuss staff workload in weekly meetings.
Therefore I need the info in the separate workbooks to feed back into the master workbook in the form of:
Project No. | Staff name | Hrs assigned week1 | week2 | etc.
There will be duplicates of names (column 1), however be next to difference project numbers (column 2), and vice versa.
I've done INDEX and MATCH in the worksheets, but now I need to do something similar to get a range which will populate the cells under the relevant date columns.
Please tell me there's a way of doing this so it automatically feeds back instead of copy and pasting.
The file is also attached.
Bookmarks