G
Guest
I have a workbook with a time sheet for each team member by month. Each
sheet contains two columns where the team member will:
Choose a Task = Column A6:A100 (multiple tasks within one sheet)
Choose a Subtask = Column B6:B100 (multiple sub-tasks within one sheet)
Columns E6:AL100 - insert labor hrs on corresponding day from row 4.
In column AN6:AN100 each task is totaled for the month for that resource.
Now I created a summary sheet.
Column A - Every possible tasks is listed (template)
Column B - Every possible sub-task is listed (template)
I want a formula that can look at column A and column B on the same row and
if it finds that combination of task-subtask to populate the total time to
date in the corresponding column E.
I would like to break it down even further - instead of it giving me one
total to date, to have column EQ represent each resource by month and it
populate that months time for that resource for that task in the
corresponding column. Not sure if that is possible. I did insert a First
and Last sheet tab for the tabs to include in the totals.
My timesheet names are by first name of resource - Month.
Amy-May07, Amy-June07, John-May07, John-June07, etc ...
I have looked for hours in the discussion groups and cannot seem to find a
solution. If a macro is the answer to this, I am macro illiterate so keep
that in mind. To just lain sum it all together, I tried SUM(IF formula but
kept getting errors.
Thanks. Any help would be appreciated.
sheet contains two columns where the team member will:
Choose a Task = Column A6:A100 (multiple tasks within one sheet)
Choose a Subtask = Column B6:B100 (multiple sub-tasks within one sheet)
Columns E6:AL100 - insert labor hrs on corresponding day from row 4.
In column AN6:AN100 each task is totaled for the month for that resource.
Now I created a summary sheet.
Column A - Every possible tasks is listed (template)
Column B - Every possible sub-task is listed (template)
I want a formula that can look at column A and column B on the same row and
if it finds that combination of task-subtask to populate the total time to
date in the corresponding column E.
I would like to break it down even further - instead of it giving me one
total to date, to have column EQ represent each resource by month and it
populate that months time for that resource for that task in the
corresponding column. Not sure if that is possible. I did insert a First
and Last sheet tab for the tabs to include in the totals.
My timesheet names are by first name of resource - Month.
Amy-May07, Amy-June07, John-May07, John-June07, etc ...
I have looked for hours in the discussion groups and cannot seem to find a
solution. If a macro is the answer to this, I am macro illiterate so keep
that in mind. To just lain sum it all together, I tried SUM(IF formula but
kept getting errors.
Thanks. Any help would be appreciated.