Hi, I collect employee times in worksheets. A separate worksheet/workbook per employee. I require a macro to consolidate all of the data from all of the workbooks per employee. For example:
Employee: Fred (Cell A2) Date: 22/02/08 (Cell C2)
(Data starts in Row 11 - Col A - Col G)
Row 11 - Project /Activity Mon Tues Wed Thurs Friday Total
Row 12 - 1234 Project 1 7 7 7 7 0 28
Row 13 - 1236 Project 2 1 1 1 1 8 12
Row 14 - 23 Same, if person is working on more projects
Row 24 - Public Holiday/Annual Leave
Row 25 - Sick
Employee: Barney (Cell A2) Date: 22/02/08 (Cell C2)
(Data starts in Row 11 - Col A - Col G)
Row 11 - Project /Activity Mon Tues Wed Thurs Friday Total
Row 12 - 1234 Project 1 7 7 7 0 20
Row 13 - 1238 Project 3 1 1 1 8 12
Rows 14 - 23 Same, if person is working on more projects but may not be.
Row 24 - Public Holiday/Annual Leave
Row 25 - Sick 8 8
If I have say 20 employees, I would get 20 returns each month. What I need is a macro that will open all the files kept in C:\mydocuments\timesheets and consolidate the employee, date, project/activity and Total from all the sheets so I get a return that looks like:
Fred 22/02/08 1234 Project 1 28
Fred 22/02/08 1236 Project 2 12
Barney 22/02/08 1234 Project 1 20
Barney 22/02/08 1238 Project 3 12
Barney 22/02/08 Sick 8
Can anybody help me with this please. I'm a novice when it comes to Excel!
Thanks
Dave.
Employee: Fred (Cell A2) Date: 22/02/08 (Cell C2)
(Data starts in Row 11 - Col A - Col G)
Row 11 - Project /Activity Mon Tues Wed Thurs Friday Total
Row 12 - 1234 Project 1 7 7 7 7 0 28
Row 13 - 1236 Project 2 1 1 1 1 8 12
Row 14 - 23 Same, if person is working on more projects
Row 24 - Public Holiday/Annual Leave
Row 25 - Sick
Employee: Barney (Cell A2) Date: 22/02/08 (Cell C2)
(Data starts in Row 11 - Col A - Col G)
Row 11 - Project /Activity Mon Tues Wed Thurs Friday Total
Row 12 - 1234 Project 1 7 7 7 0 20
Row 13 - 1238 Project 3 1 1 1 8 12
Rows 14 - 23 Same, if person is working on more projects but may not be.
Row 24 - Public Holiday/Annual Leave
Row 25 - Sick 8 8
If I have say 20 employees, I would get 20 returns each month. What I need is a macro that will open all the files kept in C:\mydocuments\timesheets and consolidate the employee, date, project/activity and Total from all the sheets so I get a return that looks like:
Fred 22/02/08 1234 Project 1 28
Fred 22/02/08 1236 Project 2 12
Barney 22/02/08 1234 Project 1 20
Barney 22/02/08 1238 Project 3 12
Barney 22/02/08 Sick 8
Can anybody help me with this please. I'm a novice when it comes to Excel!
Thanks
Dave.