G
Guest
I am needing help - after days of searching the discussions and trying a few
suggestions, I cannot seem to find an answer to my issue.
I have timecards of 10 people with a timecard for each month (each on a
seperate worksheet). Each timecard starts with 5 columns which include list
boxes which each person will populate based off the tasks they clocked time
to. Column A includes a task, B a subtask, C another subtask, etc. The far
right column (AP) sums the total to date for the month of time on that
task/subtask/subtask on that particular row.
Now I need to consolidate everyone's time on each type of task-subtask
variation that was chosen on each timecard. I created a Master "Data" page
with everyone's name in columns and each variation of the tasks in rows. I
also have the columns in a setup for each month for each team. At the end of
the row I will have it sum to give me the total for the entire project for
each task-subtask.
I know this is geting a little extreme for excel but it is the program I
know the best. Access it has been too long but I know this would have been a
preferable method. I am under a time crunch so I was wanting to put
something together quickly but I am finding that not to be the case. I am
also macro deficient, so please take that into account.
Thanks.
suggestions, I cannot seem to find an answer to my issue.
I have timecards of 10 people with a timecard for each month (each on a
seperate worksheet). Each timecard starts with 5 columns which include list
boxes which each person will populate based off the tasks they clocked time
to. Column A includes a task, B a subtask, C another subtask, etc. The far
right column (AP) sums the total to date for the month of time on that
task/subtask/subtask on that particular row.
Now I need to consolidate everyone's time on each type of task-subtask
variation that was chosen on each timecard. I created a Master "Data" page
with everyone's name in columns and each variation of the tasks in rows. I
also have the columns in a setup for each month for each team. At the end of
the row I will have it sum to give me the total for the entire project for
each task-subtask.
I know this is geting a little extreme for excel but it is the program I
know the best. Access it has been too long but I know this would have been a
preferable method. I am under a time crunch so I was wanting to put
something together quickly but I am finding that not to be the case. I am
also macro deficient, so please take that into account.
Thanks.