Totals from Seperate Worksheets to One Consolidated Sheet

**RudeRam** · 05-20-2006, 11:56 AM

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

Ardus Petus · 05-20-2006, 12:25 PM

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

I will be glad to help.
--
AP

"RudeRam" <RudeRam.2845hy_1148140800.9806@excelforum-nospam.com> a écrit
dans le message de news:
RudeRam.2845hy_1148140800.9806@excelforum-nospam.com...
>
> 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
>

**RudeRam** · 05-20-2006, 01:04 PM

Ardus

Here is the link

http://cjoint.com/?futdNwiLS6

Rude

Ardus Petus · 05-21-2006, 02:50 AM

I don't thik you really need an UserForm for that.

I made your code work: http://cjoint.com/?fviRphAnu6

HTH
--
AP

"RudeRam" <RudeRam.2848qn_1148145001.4273@excelforum-nospam.com> a écrit
dans le message de news:
RudeRam.2848qn_1148145001.4273@excelforum-nospam.com...
>
> 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
>

**RudeRam** · 05-21-2006, 12:36 PM

AP

I posted the wrong workbook, this is the one I need help with

http://cjoint.com/?fvsI1l1uFx

Sorry for the confusion

Rude

Ardus Petus · 05-21-2006, 01:15 PM

I can see no difference withe the oroginal workbook!

Does my solution fit your needs?

Cheers
--
AP

"RudeRam" <RudeRam.28620m_1148229600.8403@excelforum-nospam.com> a écrit
dans le message de news:
RudeRam.28620m_1148229600.8403@excelforum-nospam.com...
>
> 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
>