Results 1 to 3 of 3

Thread: Adding multiple worksheets to a file and having a summary page automatically update

  1. #1
    Acolyte GTretick's Avatar
    Join Date
    Jul 2015
    Location
    Canada
    Posts
    33
    Articles
    0
    Excel Version
    365

    Adding multiple worksheets to a file and having a summary page automatically update



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am creating a file where users will use an input worksheet to enter in some key data each day. Each day will have it's own worksheet but not necessarily one for each consecutive day (days can be skipped). As worksheets are copied and renamed to create a new day, I would like a summary worksheet to recognize its creation and pick up some key data.

    I've included a dummy workbook with basic direct link formulas to show what is being picked up. (Highlighted in yellow in the workbook). Linking each worksheet manually as it is added is not the solution I'm looking for.

    I've contemplating pre-populating the workbook with multiple worksheets but that is not my ideal solution.

    Finally, I would like the calculation strain on the document to be as minimal as possible as extended waiting time to recalculate as data is entered is not desirable.

    Does such a solution exist? I'm open to moving layout of cells around if that happens to make the solution easier
    Attached Files Attached Files

  2. #2
    Neophyte csquared013's Avatar
    Join Date
    Nov 2020
    Location
    Santa Fe
    Posts
    2
    Articles
    0
    Excel Version
    2010
    Did you ever find a solution to this?

    I'm too new to VBA to do it for you but this seems like something to put in the VBA chat and I'm sure someone would be able to sling you some code. I'm thinking it would just need to pull particular data points from the worksheets if your data is always formatted consistently, and then just loop through all worksheets in the workbook. Code could execute upon opening the workbook and you'd be good to go.

  3. #3
    Acolyte GTretick's Avatar
    Join Date
    Jul 2015
    Location
    Canada
    Posts
    33
    Articles
    0
    Excel Version
    365
    No I haven't found a good solution yet. In my case once the templated worksheet is duplicated, it may change in that rows could be added if a particular day has a heavy amount of one category. so for instance if the total for that category was set up on cell F15, it may well end up on cell F23 (or any other similar range past row 15) in some cases. The solution would have to start with code in the various worksheets finding the various data points and exporting them to the summary sheet. At which point it would have to create a new row in the summary to house the data in the newly duplicated worksheet.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •