Data Consolidation w/ Multiple List Boxes
 

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.

Data Consolidation w/ Multiple List Boxes
 

Can you send sample plus explanation to:

toppers at REMOVETHISjohntopley.fsnet.co.uk

"Gayla" wrote:

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.

Data Consolidation w/ Multiple List Boxes
 

Could you send an email to and I will reply with details.
Thanks.

"Toppers" wrote:

Can you send sample plus explanation to:

toppers at REMOVETHISjohntopley.fsnet.co.uk

"Gayla" wrote:

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.