Create timesheet for multiple users

[besico]

I have a timesheet I wish to create. Below is the format I wish to sen
it out in. I need ot be able to sort final data by (employee
department, project, activity and date)

I would like to collate in a central worksheet for a number o
employees so I can interrogate (i.e. using pivots).
How am I best to achive this?
From reading other posts I imagine one workbook per employee with 5
sheets each. Each can complete per week and it will populate a summar
sheet in each workbook. I can then use some code to extract the summar
from each workbook every week into a central file for collatio
(rondebruin??)....how???
A nice additon would be to be able to update the projects available an
task lists from validation drop downs. How to keep this upto date i
all workbooks?
I understand I need all workbooks in one folder to do this.

Alternatively if you have different idea I'm open to all ideas

Attachment filename: timesheet template draft.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=62916

 

[Frank Kabel]

Hi
if all users have access to one network location I would
not use Excel for this (sending out files, combining them,
etc.). I would set-up a database (e.g. MS Access) for the
data entry. This has the benefit of:
- all data is stored in one place
- multi-user access
- if you make changes to the static data ALL users will
see them
- easier to combine the data

If you like you can use Excel (e.g. pivot tables) for
reporting ppurposes. No problem to use the database as
datasource for your pivot report.