Need to aggregate employee timesheets into a summary sheet

[cfell]

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

[cfell]

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

[cfell]

Anyone? I would really appreciate some help.

thanks,
Christian

[PietBom]

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.

[AB33]

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.

[PietBom]

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.

[cfell]

Thanks Piet.

I will give your solution a try.

Kind Regards,
Christian

[cfell]

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

thanks,
Christian

[cfell]

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

[PietBom]

Christian,

I added a column..........

[cfell]

thanks Piet.

this is awesome

[cfell]

Thanks Piet.

This is awesome. Nothing else really required.

Kind Regards,
Christian