+ Reply to Thread
Results 1 to 3 of 3

multi sheet log with summary sheet that auto populates

  1. #1
    Registered User
    Join Date
    03-20-2011
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2010
    Posts
    27

    multi sheet log with summary sheet that auto populates

    I tried asking this in another thread but maybe i wasn't asking my question right. I am trying to keep tract of an account. The account value could go up or down each month so I don't think MIN or MAX will work for me. I have a sheet for each month and a summary sheet that I want to report the latest month's value I have entered.

    For example: If sheet (JAN) has a value of $200 in cell A2 and sheet (FEB) has a value of $190 in cell A2 then I want my (Summary) sheet to have a value of $190 in cell A2. But once I enter a new value, say $210 into cell A2 of the (MAR) sheet then I want cell A2 of the (Summary) sheet to change automatically and report $210. I really don't want to do a bunch of IF statements if I can help it. I searched for an answer and found similar formula's that use INDIRECT but I'm not sure how I would use it for what I am trying to do. I have attached a log to this that kind of represents what I want. It doesn't have any code but the values and results are what I'm looking for. Any help would be greatly appreciated. Thanks!
    Attached Files Attached Files
    Last edited by IZAKK; 03-24-2011 at 09:10 PM.

  2. #2
    Registered User
    Join Date
    03-20-2011
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: multi sheet log with summary sheet that auto populates

    Anyone have any ideas? Any help would be appreciated. Thanks

  3. #3
    Registered User
    Join Date
    03-20-2011
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: multi sheet log with summary sheet that auto populates

    Should I post this in another area?

+ 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