LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pastor Cliff
 
Posts: n/a
Default Summarizing totals of all worksheets to one worksheet?

I have Excel 2003 and I would like to know how to carry my totals from my
monthly worksheets (which contains 4 different totals per worksheet) to a
single worksheet that would summarize all 12 worksheets and would seperately
list the annual total of all 4 totals. Right now I am having to go back and
forth between the different worksheets to enter each total (from each month)
to accomplish this task. If it could be done automatically it would help me
out greatly.
My knowledge is limited, but if you could help me I would be greatful.
Thanks,
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy worksheet & maintain cell reference across worksheets dingy101 Excel Worksheet Functions 3 January 2nd 06 10:51 AM
Transferring date from multiple worksheets to a "totals" worksheet. tonyDeBrasco Excel Discussion (Misc queries) 3 July 22nd 05 05:43 PM
Need to have multiple worksheets use a single worksheet storm5527 Excel Worksheet Functions 1 April 22nd 05 11:25 AM
Search/Match between 2 x separate Worksheets and populate result in third worksheet Alan Bartley Excel Discussion (Misc queries) 1 April 11th 05 05:21 AM
how do i link a number of worksheets to one master worksheet? Rusty Excel Worksheet Functions 0 January 24th 05 08:49 AM


All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"