software

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: www.excelforum.com/member.php...foamp;userid=8818
View this thread: www.excelforum.com/showthread...hreadid=543973Please upload your Workbook on cjoint.com/

I will be glad to help.
--
AP

quot;RudeRamquot; gt; a écrit
dans le message de news:
...
gt;
gt; I have searched here on the board but can find the solution to my
gt; problem...
gt;
gt; I have a workbook with a consolidated hours worked and each department
gt; has it's own time sheet page where each persons total for the week is
gt; linked to the consolidated page. I have to add a special events sheet
gt; (the format and such is the same as the dept time sheet) The problem I
gt; am running into is how I can add John Does time from the special events
gt; page and his department totals to the consolidated page?
gt;
gt; I hope I have made some sense of this to you all,
gt;
gt; TIA
gt; Rude
gt;
gt; PS I can supply a copy of the workbook if needed
gt;
gt;
gt; --
gt; RudeRam
gt;
gt;
gt; ------------------------------------------------------------------------
gt; RudeRam's Profile:
gt; www.excelforum.com/member.php...foamp;userid=8818
gt; View this thread: www.excelforum.com/showthread...hreadid=543973
gt;

Ardus

Here is the link

cjoint.com/?futdNwiLS6

Rude--
RudeRam------------------------------------------------------------------------
RudeRam's Profile: www.excelforum.com/member.php...foamp;userid=8818
View this thread: www.excelforum.com/showthread...hreadid=543973I don't thik you really need an UserForm for that.

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

HTH
--
AP

quot;RudeRamquot; gt; a écrit
dans le message de news:
...
gt;
gt; Ardus
gt;
gt; Here is the link
gt;
gt; cjoint.com/?futdNwiLS6
gt;
gt; Rude
gt;
gt;
gt; --
gt; RudeRam
gt;
gt;
gt; ------------------------------------------------------------------------
gt; RudeRam's Profile:
gt; www.excelforum.com/member.php...foamp;userid=8818
gt; View this thread: www.excelforum.com/showthread...hreadid=543973
gt;

AP

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

cjoint.com/?fvsI1l1uFx

Sorry for the confusion

Rude--
RudeRam------------------------------------------------------------------------
RudeRam's Profile: www.excelforum.com/member.php...foamp;userid=8818
View this thread: www.excelforum.com/showthread...hreadid=543973I can see no difference withe the oroginal workbook!

Does my solution fit your needs?

Cheers
--
AP

quot;RudeRamquot; gt; a écrit
dans le message de news:
...
gt;
gt; AP
gt;
gt; I posted the wrong workbook, this is the one I need help with
gt;
gt; cjoint.com/?fvsI1l1uFx
gt;
gt; Sorry for the confusion
gt;
gt; Rude
gt;
gt;
gt; --
gt; RudeRam
gt;
gt;
gt; ------------------------------------------------------------------------
gt; RudeRam's Profile:
gt; www.excelforum.com/member.php...foamp;userid=8818
gt; View this thread: www.excelforum.com/showthread...hreadid=543973
gt;

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

cjoint.com/?fzefyjawyY

Thanks Again--
RudeRam------------------------------------------------------------------------
RudeRam's Profile: www.excelforum.com/member.php...foamp;userid=8818
View this thread: www.excelforum.com/showthread...hreadid=543973