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. |
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. |
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 |
All times are GMT +1. The time now is 10:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com