charstoy
04-14-2009, 03:03 PM
Hi Folks,
I am helping a coworker with a task and would like advice on how to proceed. We use Excel 2002.
Her division (R&D) uses a standard timesheet that is completed and returned via email monthly (sometimes weekly). The worksheet lists all current projects, and the engineers add additional rows to their worksheets when they start a new project that is not already listed.
We are trying to automate the time collecting portion of my coworker's job, and want to integrate all of the emailed timesheets into a single worksheet. Currently she is entering the data manually.
I have tried to use the shared workbook/compare-and-merge function, but because many engineers can work on the same project, it isn't accumulating time but replacing it with each new merged sheet.
The employees are not interested in working with *anything* complicated (these folks are fairly inexperienced with excel). As such, the existing worksheet is basic with a pre-filled list of projects - all they need to do is add their time.
I have attached an example of the master that is currently used.
Really, I am just looking for a direction to move in; wondering whether this is outside the realm of Excel, and/or the parameters we are working with.
Thanks for your time,
Charlene
I am helping a coworker with a task and would like advice on how to proceed. We use Excel 2002.
Her division (R&D) uses a standard timesheet that is completed and returned via email monthly (sometimes weekly). The worksheet lists all current projects, and the engineers add additional rows to their worksheets when they start a new project that is not already listed.
We are trying to automate the time collecting portion of my coworker's job, and want to integrate all of the emailed timesheets into a single worksheet. Currently she is entering the data manually.
I have tried to use the shared workbook/compare-and-merge function, but because many engineers can work on the same project, it isn't accumulating time but replacing it with each new merged sheet.
The employees are not interested in working with *anything* complicated (these folks are fairly inexperienced with excel). As such, the existing worksheet is basic with a pre-filled list of projects - all they need to do is add their time.
I have attached an example of the master that is currently used.
Really, I am just looking for a direction to move in; wondering whether this is outside the realm of Excel, and/or the parameters we are working with.
Thanks for your time,
Charlene