+ Reply to Thread
Results 1 to 3 of 3

Simplifying Summary Sheet from multiple sheets in same workbook

  1. #1
    Registered User
    Join Date
    12-04-2008
    Location
    Birmingham, UK
    MS-Off Ver
    Office 2007
    Posts
    43

    Simplifying Summary Sheet from multiple sheets in same workbook

    I have inherited a workbook which is being used to track differences between forecasted savings and actual savings on a monthly and year to date basis. See attached sample, I have removed the financial data but the formulaes remain.

    The problems I have are with the formulae used in the summary page. They seem very cumbersome and there must be a simpler way to "pull" the data through.

    Where I am struggling is that the individual worksheets are not a standard layout therefore I'm not sure how to reference the various cells in the summary sheet to the individual workshets.

    Each month a new workboook is created by copying the old renaming it to the current month and changing the cell references.

    Any help would be appreciated.
    Last edited by dcaraher; 08-19-2009 at 05:32 AM. Reason: additional information

  2. #2
    Registered User
    Join Date
    12-04-2008
    Location
    Birmingham, UK
    MS-Off Ver
    Office 2007
    Posts
    43

    Re: Simplifying Summary Sheet from multiple sheets in same workbook

    No reason other than to bump!

  3. #3
    Registered User
    Join Date
    12-04-2008
    Location
    Birmingham, UK
    MS-Off Ver
    Office 2007
    Posts
    43

    Re: Simplifying Summary Sheet from multiple sheets in same workbook

    Sorry for the second bump. Promise this is the last time.

+ 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