Date Range with User Form?

[Daniel]

I'm trying to create a weekly production summary for some employees, but I
need some ideas/help.

We track production on a daily basis, there is a workbook created everyday
from a template. Each workbook has the name mm/dd/yyyy XXXX X. I need to
somehow create a new workbook that will contain weekly results for employees
for a specific date range. The work weeks are Monday - Saturday and each
shift starts at 00:00. This is on a network and we don't have Access on our
end or I would be using that instead to create a database. SO, I was thinking
of using a user form to select the start and end dates (files) and have it
print the (employee production) for a weekly or given time frame if possible.

Could really use some help on this. My boss decided that we would start a
new incentive program for production results, but like I said above we are
only tracking daily results and it would take me forever to manually go
through each file to figure out the results.

 

[Socko]

I am not sure exactly what you want! But I am sure whatever you are
asking for can be achieved with managing the dailyperformance results.
You can store the data in a spreadsheet, one sheet for one day, and
when you want to show the performance for a week, month, you can
consolidate into one sheet and use pivot.

I tried to create a workbook with sample pivot and data... Have a
look....
http://www.sockofiles.350.com/perfmanagement.xls


I hope this helps.

Selva V Pasupathy
For more info on Excel and resources,
please visit: http://socko.wordpress.com/

 

[Daniel]

Thanks for your replies...

Here is a sample file: http://www.sendspace.com/file/zd1tht

What I'm trying to get is a weekly summary for sheet "Hours Bills". The most
important information is in column F & H. It would be nice to pull all of
this information to get a summary for each employee. The goal is to pull
weekly results, but it would be nice to enter a specific date range and get
the employees production. Columns J:N are normally hidden but used to get
production results. It's a simple formula - Bills Worked (column F) / Trailer
Hours (column N).

@Socko that would be perfect but I would have to go through too many files
(unless there is an easier way).

Hope that makes more sense.