Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
mj
 
Posts: n/a
Default How do I calculate cells across Excel 2003 workbooks?

I have three different workbook files stored in the same folder and I want to
have the three worksheets in each of the three workbooks totaled in a new
workbook file. I am trying to create a quarterly report from three months of
data. All data is located in the same cells in the worksheets in each of the
workbooks.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Barb Reinhardt
 
Posts: n/a
Default How do I calculate cells across Excel 2003 workbooks?

If the different workbook files were all in the same workbook, it would be a
lot easier. Can that be done?

"mj" wrote in message
...
I have three different workbook files stored in the same folder and I want
to
have the three worksheets in each of the three workbooks totaled in a new
workbook file. I am trying to create a quarterly report from three months
of
data. All data is located in the same cells in the worksheets in each of
the
workbooks.



  #3   Report Post  
Posted to microsoft.public.excel.newusers
flummi
 
Posts: n/a
Default How do I calculate cells across Excel 2003 workbooks?

If you have all workbooks open you can use them in any cell references
by selecting the appropriate window and worksheet and cell. Excel will
take care of the file paths if you close the workbooks (the summary
workbook last)

Hans

Reply
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
Excel 2003 links are not updating between workbooks Tami C Excel Worksheet Functions 3 October 11th 05 02:03 AM
Can you Link 3 cells into 1 in Excel 2003 lin Excel Worksheet Functions 2 June 8th 05 09:38 AM
Everytime I need to format cells or text, Excel 2003 takes a lot of time or free Florimar Agostini via OfficeKB.com Excel Discussion (Misc queries) 1 April 1st 05 06:29 AM
Can't Copy and Paste between Excel 2003 Workbooks wllee Excel Discussion (Misc queries) 6 March 30th 05 02:59 PM
Excel 2003 isn't updating my cells [email protected] Excel Worksheet Functions 7 November 5th 04 05:05 PM


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

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

About Us

"It's about Microsoft Excel"