Hi everyone!

I need some help. Our company is currently using a time sheet that we make in word. So each chunk of time spent on each project is recorded in a table in word. Then there is a page for each client as well as our own company's page, so that each client can see the breakdown of hours we have spent working on their projects. The problem is, it is very tedious to enter each chunk of work into word two times (once for the master copy for our company and once for the client). I am trying to make a new timesheet in excel that has an input page and a VBA program that automatically produces a new sheet for every client involved in that pay period and automatically puts the tasks for that client into their respective time sheet. I have attached an example file that shows how the input and output should look. Each separate client's time sheet needs to be created on a new sheet. If each sheet could then be printed to a separate page of a pdf document that would be awesome too. I do a fair bit of simple VBA programming, but I am totally stumped with this one. The biggest thing is to get excel to create the new sheets and sort the data by the client (which can be chosen from a drop down list as I have shown in the attached sheet.) Please, any help I could get would be awesome. Thanks so much!

Brad
Timesheet.xlsx