+ Reply to Thread
Results 1 to 14 of 14

Formula auto update

Hybrid View

  1. #1
    Registered User
    Join Date
    01-14-2017
    Location
    Pakistan
    MS-Off Ver
    Ms Office 2016
    Posts
    35

    Thumbs up Formula auto update

    Thanks for interest in my post,
    Sorry for weak English,
    Sir, I think you also did not understand, what my problem.
    I have already placed sumif Formula in Monthly sheet for Monthly Report. Now i want a formula that auto update that sumif formula in monthly sheet,
    as i have used sum if formula in column F to L.
    As now i have created 4 sheets before monthly sheet, And in Monthly sheet formula is =SUMIF('02 DEC'!$B:$B,MONTHLY!$B6,'02 DEC'!F:F)+SUMIF('03 DEC'!$B:$B,MONTHLY!$B6,'03 DEC'!F:F)+SUMIF('04 DEC'!$B:$B,MONTHLY!$B6,'04 DEC'!F:F)+SUMIF('05 DEC'!$B:$B,MONTHLY!$B6,'05 DEC'!F:F)

    I want auto update above formula If I enter new sheet like ''06 DEC''. Then formula should auto update by the name of sheet "06 Dec" in Monthly sheet cells E5 to L403.
    AS adding new sheet "06 DEC"
    =SUMIF('02 DEC'!$B:$B,MONTHLY!$B6,'02 DEC'!F:F)+SUMIF('03 DEC'!$B:$B,MONTHLY!$B6,'03 DEC'!F:F)+SUMIF('04 DEC'!$B:$B,MONTHLY!$B6,'04 DEC'!F:F)+SUMIF('05 DEC'!$B:$B,MONTHLY!$B6,'05 DEC'!F:F)+SUMIF('06 DEC'!$B:$B,MONTHLY!$B6,'06 DEC'!F:F)


    Is this is possible?
    I think this is possible......
    Or any relevant formula, which sum all previous sheet's specific value of cells..
    Thanks,,,
    And Ignore if you don't understand,,
    Attached Files Attached Files
    "M. Shahbaz Anwar Advocate"

+ 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. Excel Auto Update with Formula
    By iqubalemco in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-12-2015, 03:13 AM
  2. [SOLVED] Auto update formula every minute
    By rtesone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2013, 01:59 AM
  3. How to run formula once, then never auto update?
    By markjh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-12-2013, 10:47 AM
  4. % formula auto update
    By Fish10800 in forum Excel General
    Replies: 2
    Last Post: 10-12-2011, 12:25 PM
  5. Possible to auto update formula?
    By apollopt in forum Excel General
    Replies: 2
    Last Post: 03-17-2010, 04:32 AM
  6. How to auto-update the formula
    By seacnlib in forum Excel General
    Replies: 1
    Last Post: 05-06-2009, 02:48 AM
  7. How to turn off auto update on a formula
    By Dave in forum Excel General
    Replies: 0
    Last Post: 02-20-2006, 05:20 PM

Tags for this Thread

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