Creating a Time Sheet

[bfrehls]

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 using excel that will automatically produce the client time sheets. I have attached the format I currently have for inputting the hours. Where I need help now is to put the information (date, description of task, time worked, and hours) for each task into the corresponding client's page automatically. I am using a list in sheet2 for the clients so that I can provide a drop down option in sheet1. Basically, I need something that will say if client=client 1, then all the other data on that line is entered into the time sheet for client 1. Sorry if this doesn't make a lot of sense, it is really hard to explain in writing. Any help would be awesome. Thanks!

Brad
Timesheet.xlsx

[dredwolf]

So, are you going to have workbooks for each "pay period", or, are you going to have multiple "master" sheets (ie- 1/pay period)?
A few more samples of possible inputs and some (at least 1!) expected clients output would help
Also, do you expect Excel to create the client pages (ie- if the client page does not exist, create it), or are you going to manually create the pages ?

[dredwolf]

Self-deleted- duplicate post

[bfrehls]

Thanks for the prompt reply! I have attached an excel file that shows what our typical finished time sheets look like. Keep in mind, they are currently done in Word, but this is the general layout. I have the master sheet (where all the activity is recorded) on the left and then an example of a client's sheet (where only the work for that client goes) on the right. It would be great if excel could create the sheets as well for each client, but if that can't be done then they could be created manually. It doesn't matter if they are created on separate sheets or not, as long as they are each individually printable, but maybe the easiest would be for it to make a new worksheet for each client that appears on this particular pay period. To summarize, I need to have excel create an output similar to what I have attached to this response using the input from a sheet similar to what I attached to my first post. Thanks so much for the help, it is very much appreciated!!

Brad
Book1.xlsx

[dredwolf]

I guess you mis-understood my request, I have no problem with your first workbook , except that I have no idea of how you expect the result to look like... a few filled in dates, a few examples of what you expect to see ( which you have provided, just not in context with your first sample ), would work
I'm pretty sure Excel VBA can create sheets as needed for clients, BUT I WANT TO SEE at least a few samples of (simulated) data and expected results please

[Marksmi]

There are excel time sheet templates online which can simplify your task. Try to search for a template that has the features you are looking for. They guide you through creating days of your project, hours and other details. You can calculate hours worked, payment and other benefits such as overtimes. You can find an example here http://www.calculatehours.com/templa...imesheets.html.
Excel sheets can track task as explained here http://www.techyv.com/questions/need...cking-opinions
For more details you can check excel support on Microsoft office website.

[bfrehls]

Thanks again for the reply. Ok, I have created one excel sheet that has exactly what I need the input and output to be. A new sheet will be created for each client, with that client's tasks on that sheet. The employee will only edit the "input" sheet and when they are finished, they will click the button described at the top of that sheet in my excel file. Once that button is clicked, a pdf should be created that has each sheet (except the input sheet and sheet 2) as a separate page. The big thing I need help with is how to get excel to create the sheets for each client and recognize which tasks go to which client and place them in the correct sheet. Then the final thing (which I don't know if it is possible) is to print them to pdf. If that isn't possible, that is ok, just as long as we get excel to create the sheets and fill the correct client sheets with their tasks. Thanks in advance for the help, please see the attached document.

Cheers,
Brad

Timesheet.xlsx

(I know the name is the same as the first one, but I have updated it)