+ Reply to Thread
Results 1 to 3 of 3

How do I calculate cells across Excel 2003 workbooks?

  1. #1
    mj
    Guest

    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. #2
    Barb Reinhardt
    Guest

    Re: 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" <mj@discussions.microsoft.com> wrote in message
    news:99DDF3D0-2951-4FEE-978B-CCA5BE40D955@microsoft.com...
    >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. #3
    flummi
    Guest

    Re: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1