LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Spreadsheet summary automatically referrences totals of worksheets

I have a spreadsheet summary sheet that references change order totals from
multiple worksheets. Each row on the spreadsheet summary references a
'subtotal' cell on sucessive change order worksheets. The total cell is the
same in each sheet. As I copy additional worksheets, is there a way to
automatically reference the total with out manually referencing the worksheet
total to the summary cell.


 
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
Summary Sheet Totals Bowtie63 Excel Discussion (Misc queries) 7 October 29th 07 07:54 PM
How do I automatically compile totals from 12 worksheets into 1? PippyKat Excel Worksheet Functions 2 June 23rd 06 02:39 PM
Copying Numerical Totals of separate worksheets to a single Summary Worksheet buster1831 Setting up and Configuration of Excel 1 February 22nd 05 08:07 AM
Copying Numerical Totals of separate worksheets to a single Summary Worksheet buster1831 Excel Discussion (Misc queries) 2 February 16th 05 11:28 PM
Copying Totals of separate worksheets to a single Summary Worksheet buster1831 Excel Discussion (Misc queries) 0 February 16th 05 10:25 PM


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