Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help - need to consolidate workbooks
Hi all
Need some help. There is now a requirement for my team to complete timesheets. Something like the attached. I have 2 sheets on there but that will actually be 2 workbooks, as an example The requirement is for each individual to complete their timesheet and drop in a folder. Our manager will then see 15 timesheets in this folder. He would then need to consolidate the timesheets into ONE workbook and ONE worksheet. They want to do some analysis etc so would need a total of all timesheets. However if you look at the timesheet - each could be different depending on how many clients that person has worked for that week. Person 1 may have 5 clients that period whilst Person 2 may have just the one. Any idea's how this can be achieved please? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help - need to consolidate workbooks
Good examples of the sources. However, you need to show us what you
want the consolidated sheet to look like.... On Feb 10, 2:49*pm, yus786 wrote: Hi all Need some help. There is now a requirement for my team to complete timesheets. Something like the attached. I have 2 sheets on there but that will actually be 2 workbooks, as an example The requirement is for each individual to complete their timesheet and drop in a folder. Our manager will then see 15 timesheets in this folder. He would then need to consolidate the timesheets into ONE workbook and ONE worksheet. They want to do some analysis etc so would need a total of all timesheets. However if you look at the timesheet - each could be different depending on how many clients that person has worked for that week. Person 1 may have 5 clients that period whilst Person 2 may have just the one. Any idea's how this can be achieved please? Thanks +-------------------------------------------------------------------+ |Filename: TimeSheet_Help.zip * * * * * * * * * * * * * * * * * * * | |Download:http://www.excelbanter.com/attachment.php?attachmentid=293| +-------------------------------------------------------------------+ -- yus786 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help - need to consolidate workbooks
On 11/02/2012 7:49 AM, yus786 wrote:
Hi all Need some help. There is now a requirement for my team to complete timesheets. Something like the attached. I have 2 sheets on there but that will actually be 2 workbooks, as an example The requirement is for each individual to complete their timesheet and drop in a folder. Our manager will then see 15 timesheets in this folder. He would then need to consolidate the timesheets into ONE workbook and ONE worksheet. They want to do some analysis etc so would need a total of all timesheets. However if you look at the timesheet - each could be different depending on how many clients that person has worked for that week. Person 1 may have 5 clients that period whilst Person 2 may have just the one. Any idea's how this can be achieved please? Thanks +-------------------------------------------------------------------+ |Filename: TimeSheet_Help.zip | |Download: http://www.excelbanter.com/attachment.php?attachmentid=293| +-------------------------------------------------------------------+ Hi Just a thought here Why go to all the trouble of having multiple sheets as opposed to having everyone enter their details into 1 centralised workbook where you can do your analysis... You could use a UserInputForm and allocate a UserID/Password as their unique ID passing their entries directly into the referenced cells. On the usersInputForm after it has passed the UserID protocol, you could have the following ComboBoxes/ValidationLists and TextBoxes: Employee: Client: Day/Date: Hours: There you go, no need for 15 spreadsheets and potentially complicated codes to roll through each and reconstruct the data, and hope there are no errors along the way. HTH Mick. |
#4
|
|||
|
|||
Quote:
Presumably there will be only ONE workbook on a shared drive somewhere? |
#5
|
|||
|
|||
Quote:
|
#6
|
|||
|
|||
However if you look at the timesheet - each could be different depending on how many clients that person has worked for that week. Person 1 may have 5 clients that period whilst Person 2 may have just the one.
____________ memory foam mattress | adjustable mattresses | memory pillow |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help on consolidate worksheets from different workbooks into one | Excel Discussion (Misc queries) | |||
Consolidate Several Workbooks into One | Excel Worksheet Functions | |||
Consolidate multiple workbooks | Excel Worksheet Functions | |||
consolidate 2 different workbooks | Excel Discussion (Misc queries) | |||
Consolidate different sheets to different workbooks | Excel Worksheet Functions |