View Single Post
  #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