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

Totals from Seperate Worksheets to One Consolidated Sheet
 

Please upload your Workbook on http://cjoint.com/

I will be glad to help.
--
AP

"RudeRam" a écrit
dans le message de news:
...

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

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

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

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

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

Totals from Seperate Worksheets to One Consolidated Sheet
 

AP,

Sorry for the long delay in responding had computer problems, I have
sorted out the correct work book now,

This is the correct workbook

http://cjoint.com/?fzefyjawyY

Thanks Again


--
RudeRam


------------------------------------------------------------------------
RudeRam's Profile: http://www.excelforum.com/member.php...fo&userid=8818
View this thread: http://www.excelforum.com/showthread...hreadid=543973