Time Log For Various Employees on Various Projects On Various Days

I have a spread sheet that we track hrs spect on capex projects. Each AFE has its own worksheet all in the same workbook. In each worksheet there is a column for employee name,Date,reg hrs,OT hrs,total hrs,employee pay rate and total dollar amount which is sum from reg hrs x pay rate and ot hrs x pay rate at time and a half and then reg and ot totals are smmed to give total dollar amount.

I want to make a emplyee overview sheet that will take emplyee name and total hrs and total amount for each afe and list them on this pagebut I am not sure how to do that and my searching has not come up with a good result.

On each AFE sheet there will be hrs for 7-10 different employees.and a employee may be on the same sheet several times with different dates.

Any ideas on how I could solve this?

I have attached a link to the file I am working with.

What we need is a way to track how much time each person spent on each specific AFE and I need to enter this time daily but it has to be reported montly. I am almost thinking I need the document I have for each person the pull that into another workbook?

This would be much easier in access but very few people at this site have access but they all have word and excel. I would like to keep it /do it in excel if at all possible but so far I am stumped over the best approach.

Please help?

Here is the link to the file https://www.dropbox.com/s/5uer25z1ca...20Example.xlsx

Piet Bom

That's awesome and it works great. I have a couple more questions though. Builing on the way you coded that is there a way I can take the summary sheet and split the info? The generate report area gives total hours per afe per employee and to the left it is detailed by entry date. I want to take the info on the left and put it on a seperate sheet named detaled employee summary and have the area with generate report button called employee summary. Can the generate report button be copied to both pages? will anything break by splitting this data?

I need to make a 3 summary sheet called AFE summary and just show the amount of hours and dollers for each AFE and not be employee or date specific. My plan is to have a workbook for each month to keep things simple unless there is a way I could choose the month for the report to generate? Is that possible? Should i be using something like a dropdown list for that? If this can work I could get rid of the month field in each AFE sheet and just base it on the date that was input I am thinking?

Or would it be better to just do a seperate workbook for each month. Sorry for so many question but I have very limited excel experience but I am having to learn fast. My company is downsizing and fired my boss and threw all his work on plus what I already had. My boss was a excel guru but I am not at this point.

Thanks for the VBA code and pivot table additions. I never even knew excel could use vba like that.

Piet Bom I have attached the file after I made some changes like removing the plant and month from the header since it is getting the date from the individual entry.

For some reason row 8 on the AFE summary displays the text blank? Did I break something? I can't seem to figure out what I did wrong.

Also when I close the file and reopen I have to enable macros each time? Is there a way to always enable macros? Is that the best thing to do? I am using excel 2010 BTW if that makes any difference but I would not think that it would?

Piet Bom

Can I remove the blanks? Where do they come from? Is the blank generated from my example sheet perhaps?