Results 1 to 1 of 1

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

  1. #1
    Seeker GTretick's Avatar
    Join Date
    Jul 2015
    Location
    Canada
    Posts
    17
    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

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
  •