View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RudeRam
 
Posts: n/a
Default 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