Carlos Ruano
Member
I don't know if what I want to do is even possible. I know it certainly is not with my current level of knowledge!!
I have added an attachment.
The first sheet, "HoursCostDistribution" is part of a tool that I receive for each new project for which my company is contracted to perform. The second sheet, "GOAL" is an example of what I want to create based on the first sheet.
As you can see, in the "HoursCostDistribution" sheet, there are Start and Stop dates for a particular type of work to be done (Code A, B, C, etc. in column B). There is also the duration of days for the work to be performed in column G. The roles that are to perform the work are across the top in Row 3.
In the "GOAL" sheet, I have listed the Roles to perform the work in column A, and the months/years during which the project is supposed to run across the top in Row 1.
What I want, is for each role to have the hours allocated to it for each given activity (codes in column B of first sheet) under the appropriate month column.
Is this possible!?! Please let me know if you have any questions!
Thank you for looking!!!
I have added an attachment.
The first sheet, "HoursCostDistribution" is part of a tool that I receive for each new project for which my company is contracted to perform. The second sheet, "GOAL" is an example of what I want to create based on the first sheet.
As you can see, in the "HoursCostDistribution" sheet, there are Start and Stop dates for a particular type of work to be done (Code A, B, C, etc. in column B). There is also the duration of days for the work to be performed in column G. The roles that are to perform the work are across the top in Row 3.
In the "GOAL" sheet, I have listed the Roles to perform the work in column A, and the months/years during which the project is supposed to run across the top in Row 1.
What I want, is for each role to have the hours allocated to it for each given activity (codes in column B of first sheet) under the appropriate month column.
Is this possible!?! Please let me know if you have any questions!
Thank you for looking!!!