+ Reply to Thread
Results 1 to 3 of 3

Data from different sheet populating into Summary sheet when new sheets are created

  1. #1
    Registered User
    Join Date
    06-24-2020
    Location
    New Zealand
    MS-Off Ver
    2010
    Posts
    7

    Data from different sheet populating into Summary sheet when new sheets are created

    Scenario:
    The original workbook contains 2 sheets "Summary" and "Template".
    When a user wants to collect data (about a child), they copy the template sheet (right mouse click/copy/move to end of same workbook). They rename the sheet with the Childs Name. They then populate the sheet with the data being collected. The name of child cell in the new sheet is populated when the sheet tab is renamed.

    Its the Summary sheet I need help with please.
    * I would like the Childs name from each sheet to populate on the Summary eg Child 1 in A2, Child 2 in A3 etc (doesn't have to be in the A column if hidden helper columns are required)
    * I would like the child's date of birth, mothers name and other data to populate in columns in the Summary sheet.

    Because the sheets will be copied & added in an ad hoc manner, as and when needed, I'm unsure which function to use and how the Summary sheet will update each time a new sheet is added.

    We're expecting up to 50 sheets per calendar year = 1 workbook.

    The users are inexperienced Excel users so looking for an easy way to populate the Summary sheet, hopefully without the need for a macro and hopefully so they don't keep coming back to me when they add additional sheets and the Summary is not updating

    Open to any options or your thoughts.
    Thanks
    Attached Files Attached Files

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

    Re: Data from different sheet populating into Summary sheet when new sheets are created

    To update new sheet name automatically into summary => VBA solution
    Without VBA, I would suggest as following:

    Create a helper column F, to list all possible "sheet name", (not a child name), like "Child 1", "Child 2",...,"Child 50"

    Any user to create a new sheet right after latest sheet "Child n", make sure name it the next one "Child n+1"

    Then in Summary sheet now can be updated automatically.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-24-2020
    Location
    New Zealand
    MS-Off Ver
    2010
    Posts
    7

    Re: Data from different sheet populating into Summary sheet when new sheets are created

    Again another really helpful post bebo021999. Thanks so much

+ 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. [SOLVED] Formula populating data from multiple sheets to summary sheet
    By $mart Group in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-13-2018, 12:58 AM
  2. Populating data from multiple sheets onto a summary sheet
    By janeml in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-10-2014, 07:17 PM
  3. Creating auto populating Summary sheet as new sheets are added to work book
    By Phraedrique in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2012, 05:01 PM
  4. Copying a template sheet and putting those multiple sheets data into a summary sheet
    By John Wolfe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2011, 06:29 PM
  5. Populating Summary Sheet From Data Sheet
    By jadown in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-02-2011, 11:11 AM
  6. Automatically enter details in Summary sheet when new sheet created
    By unley in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-19-2010, 05:13 PM
  7. Updating Summary Sheet from Newly Created Sheet
    By Applem21 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-07-2010, 01:16 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