LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
al al is offline
external usenet poster
 
Posts: 363
Default Grand totals on another worksheet.

I have a worksheet for user data entry that consists of a few columns of
names and descriptions and monthly columns for quantities. Users enter their
data and are free to create subtotals based on the text column entries to
evaluate their data. Each workbook also needs the monthly grand totals on
other worksheets, regardless of whether the user has subtotals on or not. Is
there any way to do this using functions, or do I have to resort to VBA?
--
Al C
 
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
Can't get Grand Totals (rows) to appear TonyG Excel Discussion (Misc queries) 1 May 24th 06 03:06 AM
Need help with grand totals in pivot table Missygal Excel Discussion (Misc queries) 1 May 16th 06 07:02 PM
PivotTable Grand Totals By Item TMore Excel Discussion (Misc queries) 4 April 29th 06 04:48 PM
More Grand Totals Amber M Excel Worksheet Functions 5 January 1st 05 02:52 PM
Grand Totals @ Same Place Amber M Excel Worksheet Functions 2 December 30th 04 07:13 PM


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