Hi - I hope someone can help me with this.
1. I have a worksheet (A) that has several columns for each week. In each column there isnumber of resources needed next to a task of a project. One column is incremental resources, next is reallocated resources and next is offshore resources. The heading of the column is week. Think of a gantt that has task and next to it is resource instead of date. the date is the heading.
2. I have a worksheet (B) that has a column for each month and year (Jan-14,Feb-14…Dec-14) that I want to summarize the resources of each week the resources needed from sheet (A) under a monthly coilumn.
3. I want to update the columns from sheet (A) that is dynamic with the resources (Associated with tasks, but don’t want the tasks copied just resource numbers) and could start in any month.
4. Sheet A each month has multiple columns as they are based on week. The month consists of 3 to 4 weeks and must sum up each weeks resource in the month.
Worksheet A
4/24/14 5/1/14 5/7/14 5/14/14 6/1/14 6/7/14 … 12/31/14
Pro1 Incremental 5 9 8 6 9 6 … 8
Proj1 ReAllocated 2 0 7 5 5 5 … 6
Proj2 Incremental 7 9 15 11 14 11 … 14
Proj2 ReAllocated 2 4 6 4 9 4 … 2
Worksheet B
Jan-14 Feb-15 Mar-14 Apr-14 May-14 Jun-14 … Dec-14
Incremental 0 0 0 13 58 40 22
ReAllocated 0 0 0 4 27 23 8
Total 0 0 0 17 85 63 30
Your help would be greatly appreciated. Thank You.
Bookmarks