+ Reply to Thread
Results 1 to 3 of 3

Running total from previous sheets with non-sequential names?

  1. #1
    Registered User
    Join Date
    07-10-2007
    Posts
    8

    Running total from previous sheets with non-sequential names?

    Hi!
    Could someone please help me figure out a formula to take a value from one sheet and add to it in Excel 2010?
    I'm naming the sheets but not necessarily numerically.
    I have done it by manually entering the sheet name but would like it to figure out the sheet name automatically based on where the sheet is located in the workbook. That way I can copy the current sheet, rename it and still have it update properly with a running total.
    Here is what I have now: =D7+'011514'!E7

    Thank you for your time!

    stubhelp.xlsx

  2. #2
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,421

    Re: Running total from previous sheets with non-sequential names?

    due to using XLM 4.0, i have had to save this workbook as macro-enabled. give it a dekko...
    - i.s.z -
    CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
    Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
    All good ideas are courtesy resources from this forum as well as others around the web.
    - e.o.m -

  3. #3
    Registered User
    Join Date
    07-10-2007
    Posts
    8

    Re: Running total from previous sheets with non-sequential names?

    Solved the problem. Thanks!!!!
    It will take me a while to decipher the INDIRECT function and the functions defined in the names but that's where I learn from things.
    Again, Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. running total subtract % of previous months
    By amartino44 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-17-2013, 01:42 PM
  2. [SOLVED] Running Total from previous page
    By Vanna in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-05-2006, 04:35 AM
  3. [SOLVED] updated running total from previous pages
    By Steve in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  4. [SOLVED] updated running total from previous pages
    By Steve in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  5. [SOLVED] updated running total from previous pages
    By Steve in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

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