Totals from Seperate Worksheets to One Consolidated Sheet

R

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
 
A

Ardus Petus

I can see no difference withe the oroginal workbook!

Does my solution fit your needs?

Cheers
 
Top