+ Reply to Thread
Results 1 to 6 of 6

SUM formula for future created sheets

  1. #1
    Registered User
    Join Date
    05-25-2020
    Location
    Norway
    MS-Off Ver
    365
    Posts
    5

    Post SUM formula for future created sheets

    Hi.
    I am currently building an Excel workbook with sheets where I enter data from different customers. I have one "main page" where I want to continually have a summary of specific input from all my sheets (e.g. customer name x, customer name y etc.).

    I understand how to make a simple sum function to summarize data from my current sheets, but is it possible to make a formula/function to include all future created sheets if all variables have a fixed placement in each sheet? (e.g. if I always summarize data from cell B4 etc.)

    Attached is a sample workbook where I try to explain. Hope that helped.

    Hope my question made sense and that someone know the answer to this.
    Thank you.
    Attached Files Attached Files
    Last edited by TiviNO; 05-25-2020 at 05:02 AM. Reason: Including workbook

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,967

    Re: SUM formula for future created sheets

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Valued Forum Contributor
    Join Date
    02-06-2013
    Location
    Germany
    MS-Off Ver
    365
    Posts
    460

    Re: SUM formula for future created sheets

    e.g. like that:

    =INDIRECT(C26&"!"&D26)
    D26 contains eg =B9 the fixed cell in the relevant sheet(s) which you would like to use
    C26 contains =''Sheet1' (note the double apostrophe at the beginning)

    You can then wrap a sum function around indirect or whatever you wish to do
    Maybe wrap an iferror around, too for as long as the new sheet doesn't exist yet

    btw - there's also ways that you can determine the sheetname of any newly added sheets automatically once you add it but it might involve some Excel 4.0 Macros I believe

  4. #4
    Registered User
    Join Date
    05-25-2020
    Location
    Norway
    MS-Off Ver
    365
    Posts
    5

    Re: SUM formula for future created sheets

    Hi,
    Sorry for late reply!
    Thanks for the help!

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2305 (Windows 11 22H2 64-bit)
    Posts
    67,600

    Re: SUM formula for future created sheets

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  6. #6
    Registered User
    Join Date
    05-25-2020
    Location
    Norway
    MS-Off Ver
    365
    Posts
    5

    Re: SUM formula for future created sheets

    I did it now Still new and could not find the solved button!

+ 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. Create Sheets, separate records, copy-paste cell values from master to created sheets
    By hishamezzat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2018, 05:31 PM
  2. Formula to sum cells across multiple sheets or future sheets
    By dLhx in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-13-2017, 02:46 PM
  3. Replies: 6
    Last Post: 12-16-2016, 04:38 PM
  4. [SOLVED] Can you have a range name of a sheets that auto updates as sheets are created?
    By juntjoo in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 10-12-2016, 12:54 PM
  5. Linking to future sheets
    By DaBrot791 in forum Excel General
    Replies: 7
    Last Post: 09-22-2014, 08:27 AM
  6. Replies: 4
    Last Post: 01-15-2014, 10:26 AM
  7. Replies: 0
    Last Post: 12-08-2005, 05:50 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