Results 1 to 3 of 3

multi sheet log with summary sheet that auto populates

Threaded View

IZAKK multi sheet log with summary... 03-23-2011, 10:27 PM
IZAKK Re: multi sheet log with... 03-24-2011, 09:10 PM
IZAKK Re: multi sheet log with... 03-24-2011, 11:43 PM
  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.

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