LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PippyKat
 
Posts: n/a
Default How do I automatically compile totals from 12 worksheets into 1?

Each month, we compile seminar information into a line item style excel
worksheet. Line items include type of seminar, number of attendees, number of
actions (blood pressure, body fat, cholesterol, sugar, etc..) taken with each
attendee, location and facilitator. For the current fiscal year, there are 9
separate worksheets. What I want to do is set the worksheets up so that the
total number of attendees and actions will automatically compile into one
worksheet giving me a combined total for the year's activities. I'm sure
this probably sounds more complicated than it is. Any suggestions or help
would be appreciated. Thank You !! PippyKat
 
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
Compile list of same cell from multiple worksheets PCakes Excel Worksheet Functions 7 August 17th 06 04:03 PM
Formula needed - automatically calculate session time totals for each user optimusprym8 Excel Worksheet Functions 2 June 22nd 06 02:01 PM
Need to stop formuls from automatically changing ThermalJay Excel Discussion (Misc queries) 4 November 22nd 05 10:18 PM
Changing a Link Mid-way Across Worksheets Frosty Excel Worksheet Functions 0 August 25th 05 12:03 AM
HELP! How do you--> Lock a set of rows but also link worksheets to FRUSTRATED Excel Discussion (Misc queries) 6 December 29th 04 10:05 PM


All times are GMT +1. The time now is 11:39 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"