| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Totals from Seperate Worksheets to One Consolidated Sheet
I have searched here on the board but can find the solution to my problem... I have a workbook with a consolidated hours worked and each department has it’s own time sheet page where each persons total for the week is linked to the consolidated page. I have to add a special events sheet (the format and such is the same as the dept time sheet) The problem I am running into is how I can add John Does time from the special events page and his department totals to the consolidated page? I hope I have made some sense of this to you all, TIA Rude PS I can supply a copy of the workbook if needed -- RudeRam ------------------------------------------------------------------------ RudeRam's Profile: http://www.excelforum.com/member.php...fo&userid=8818 View this thread: http://www.excelforum.com/showthread...hreadid=543973 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Totals from Seperate Worksheets to One Consolidated Sheet
Ardus Here is the link http://cjoint.com/?futdNwiLS6 Rude -- RudeRam ------------------------------------------------------------------------ RudeRam's Profile: http://www.excelforum.com/member.php...fo&userid=8818 View this thread: http://www.excelforum.com/showthread...hreadid=543973 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Totals from Seperate Worksheets to One Consolidated Sheet
I don't thik you really need an UserForm for that.
I made your code work: http://cjoint.com/?fviRphAnu6 HTH -- AP "RudeRam" a écrit dans le message de news: ... Ardus Here is the link http://cjoint.com/?futdNwiLS6 Rude -- RudeRam ------------------------------------------------------------------------ RudeRam's Profile: http://www.excelforum.com/member.php...fo&userid=8818 View this thread: http://www.excelforum.com/showthread...hreadid=543973 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Totals from Seperate Worksheets to One Consolidated Sheet
AP I posted the wrong workbook, this is the one I need help with http://cjoint.com/?fvsI1l1uFx Sorry for the confusion Rude -- RudeRam ------------------------------------------------------------------------ RudeRam's Profile: http://www.excelforum.com/member.php...fo&userid=8818 View this thread: http://www.excelforum.com/showthread...hreadid=543973 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Totals from Seperate Worksheets to One Consolidated Sheet
I can see no difference withe the oroginal workbook!
Does my solution fit your needs? Cheers -- AP "RudeRam" a écrit dans le message de news: ... AP I posted the wrong workbook, this is the one I need help with http://cjoint.com/?fvsI1l1uFx Sorry for the confusion Rude -- RudeRam ------------------------------------------------------------------------ RudeRam's Profile: http://www.excelforum.com/member.php...fo&userid=8818 View this thread: http://www.excelforum.com/showthread...hreadid=543973 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Totals on Seperate Page | Excel Discussion (Misc queries) | |||
| Adding totals from numerous worksheets | Excel Worksheet Functions | |||
| Match and Sort for two range of data on different worksheets? | New Users to Excel | |||
| calculate totals of 5 sheets on to 6th sheet. | Excel Worksheet Functions | |||
| Copying Numerical Totals of separate worksheets to a single Summary Worksheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
