Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 links are not updating between workbooks | Excel Worksheet Functions | |||
Can you Link 3 cells into 1 in Excel 2003 | Excel Worksheet Functions | |||
Everytime I need to format cells or text, Excel 2003 takes a lot of time or free | Excel Discussion (Misc queries) | |||
Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) | |||
Excel 2003 isn't updating my cells | Excel Worksheet Functions |