I have a spreadsheet that lists the following:
"A7" - Project's #
"B7" - Project's Name
"C7" - Project's Lead
"D7" - Project's Stage
"E7-E15" - Employees on that project
"A16" - Next Project's #
"B16" - Next Project's Name
"C16" - Next Project's Lead
"D16" - Next Project's Stage
"E16-E24" - Employees on that project
An so on.
Beginning in column "F" and going through "DL", I have week ending dates beginning with 7/30/11 and ending with 9/13/13.
The hours that each person is planned to work on each project each week is listed under the week ending dates.
What I am trying to do is sum the totals by each person, by week at the bottom of the sheet.
I was thinking of using a pivot table. Since not every employee will be listed on each project and I never know when a new employee might be added, I thought this would be the best way to group all hours worked by employee per week (regardless of the project). Is this the best way to handle it? I didn't really want to use a pivot table since others will be updating this form, adding projects, people, etc. I'm worried that the pivot table selection won't capture everything if someone adds rows above.
"A7" - Project's #
"B7" - Project's Name
"C7" - Project's Lead
"D7" - Project's Stage
"E7-E15" - Employees on that project
"A16" - Next Project's #
"B16" - Next Project's Name
"C16" - Next Project's Lead
"D16" - Next Project's Stage
"E16-E24" - Employees on that project
An so on.
Beginning in column "F" and going through "DL", I have week ending dates beginning with 7/30/11 and ending with 9/13/13.
The hours that each person is planned to work on each project each week is listed under the week ending dates.
What I am trying to do is sum the totals by each person, by week at the bottom of the sheet.
I was thinking of using a pivot table. Since not every employee will be listed on each project and I never know when a new employee might be added, I thought this would be the best way to group all hours worked by employee per week (regardless of the project). Is this the best way to handle it? I didn't really want to use a pivot table since others will be updating this form, adding projects, people, etc. I'm worried that the pivot table selection won't capture everything if someone adds rows above.