+ Reply to Thread
Results 1 to 10 of 10

Need to aggregate employee timesheets into a summary sheet

  1. #1
    Registered User
    Join Date
    01-30-2013
    Location
    Near
    MS-Off Ver
    Excel 2007
    Posts
    7

    Need to aggregate employee timesheets into a summary sheet

    Hi,

    I am pretty stumped with the task that I have been given, and looking for a little guidance. I work for a project based company, each employee timesheet is based on three categories: billable, non-billable, and misc. such as sick day, stat holiday etc... The task that I have been given is to develop a macro to automatically take each employee timesheet and parse it correctly into a summary sheet. So, one column per employee, each column divided into the three sections that i wrote about above. In the left most columns would be project identifiers, ie. T5102 to correspond with a project, and one column to the right would be a project description. Moreover, I don't want to have project numbers or descriptions repeated. I will attach a copy of a sample timesheet, and summary sheet.

    I would appreciate any help.

    Thanks,
    Christian
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-30-2013
    Location
    Near
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Need to aggregate employee timesheets into a summary sheet

    this is the code that i have managed to get so far. However, it does not seem to be pasting anything into the summary sheet. I adapted it from something that i found on Microsoft's site.
    Please Login or Register  to view this content.
    I would appreciate any and all help that i can get.

    thanks,
    Christian
    Last edited by cfell; 03-20-2013 at 02:24 PM. Reason: to say thanks

  3. #3
    Registered User
    Join Date
    01-30-2013
    Location
    Near
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Need to aggregate employee timesheets into a summary sheet

    Anyone? I would really appreciate some help.

    thanks,
    Christian

  4. #4
    Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    272

    Re: Need to aggregate employee timesheets into a summary sheet

    I just started on your topic.
    Now discovered that this is a complete application which will take a few hours to develop it.
    But it is an interesting subject.
    So coming weekend I will spend some time on it.
    Kind regards,
    Piet Bom

  5. #5
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: Need to aggregate employee timesheets into a summary sheet

    You may have got it from the web, but it is written by Ron Deburin. You can visit his site. He has lots of staff on merging.
    The code you have copies only from the first sheet.

    Please Login or Register  to view this content.
    If you want to copy more than the first sheet, you need a different code, but Ron has codes for different many scenarios.

  6. #6
    Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    272

    Re: Need to aggregate employee timesheets into a summary sheet

    This is my first design as a start.
    Unzip the attached file into a separate folder.
    Then open the summary file.
    Put in the path name of the location where you saved the files.
    Put in the date of the week ending.
    Click on button: [Get Timesheets]
    You will get a database of all timesheets of the specified week.
    Then go to sheet Pivot1 and Refresh it.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    01-30-2013
    Location
    Near
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Need to aggregate employee timesheets into a summary sheet

    Thanks Piet.

    I will give your solution a try.

    Kind Regards,
    Christian

  8. #8
    Registered User
    Join Date
    01-30-2013
    Location
    Near
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Need to aggregate employee timesheets into a summary sheet

    Hi Piet. Great. I will take a closer look at the code tomorrow at work.

    thanks,
    Christian

  9. #9
    Registered User
    Join Date
    01-30-2013
    Location
    Near
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Need to aggregate employee timesheets into a summary sheet

    Thanks for all the help Piet. I have also automated the pivot table. In your opinion to make it possible to sort the imported values into chargeable non-chargeable etc. would it be better to simply add a column in the timesheets or would it be better to sort them in the imported sheet?

    thanks,
    Christian

  10. #10
    Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    272

    Re: Need to aggregate employee timesheets into a summary sheet

    Christian,

    I added a column..........
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    01-30-2013
    Location
    Near
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Need to aggregate employee timesheets into a summary sheet

    thanks Piet.

    this is awesome

  12. #12
    Registered User
    Join Date
    01-30-2013
    Location
    Near
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Need to aggregate employee timesheets into a summary sheet

    Thanks Piet.

    This is awesome. Nothing else really required.

    Kind Regards,
    Christian

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1