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
Bookmarks