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.

 

[Simon Lloyd]

Can you give some specifics? i.e where the employee sheets are stored?
what data do you want to get and by what criteria? what are the
ranges?......etc, there's so much more information needed before we can
begin to give you an answer!


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)

 

[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.