Totals from Seperate Worksheets to One Consolidated Sheet

[RudeRam]

I have searched here on the board but can find the solution to m
problem...

I have a workbook with a consolidated hours worked and each departmen
has it’s own time sheet page where each persons total for the week i
linked to the consolidated page. I have to add a special events shee
(the format and such is the same as the dept time sheet) The problem
am running into is how I can add John Does time from the special event
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 neede

 

[Ardus Petus]

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

I will be glad to help.

 

[RudeRam]

Ardus

Here is the link

http://cjoint.com/?futdNwiLS6

Rude

 

[Ardus Petus]

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

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

HTH

 

[RudeRam]

AP

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

http://cjoint.com/?fvsI1l1uFx

Sorry for the confusion

Rud

 

[Ardus Petus]

I can see no difference withe the oroginal workbook!

Does my solution fit your needs?

Cheers

 

[RudeRam]

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