+ Reply to Thread
Results 1 to 8 of 8

Auto-populate front sheet or summary sheet with data from multiple tabs or sheets

  1. #1
    Registered User
    Join Date
    07-28-2021
    Location
    London, England
    MS-Off Ver
    365, 2008 Excel
    Posts
    5

    Lightbulb Auto-populate front sheet or summary sheet with data from multiple tabs or sheets

    Hello experts
    I have a challenge that I would really welcome some help with.
    I have been tasked with creating a spreadsheet that captures similar data for three different business areas in three separate tabs. Simple enough
    Then, ideally I would like a front sheet, or summary sheet that takes some of this data (the high-level detail) from all of the tabs and automatically populates it into one consolidated view, displayed in date order.

    The purpose: my boss is in charge of a team of three event managers, each with their own account. He'd like one view of everything that we are working on, rather than having to check across three different databases or spreadsheets. He only needs to see certain level of detail, whereas the managers need to see all of the detail associated with their events. We're trying to reduce duplication of work.
    Think of it as a internal version (three data tabs) and an external version (summary sheet), that he can easily look-over and in turn, share with his boss.

    I know I'm missing the obvious of simply hiding columns and using one simple list for all... but we need to keep the data separate.

    I've attached an example for the month of September 2021, but am looking to create this for all the months of the year.

    The second challenge is that I am working with a 2008 version of Excel! (my goodness me!), so perhaps this challenge is three-fold:
    1. Is this even possible?
    2. If so, is it possible in 2008 Excel
    3. If not, what would I need to enable / upgrade to to get this working

    I've had a quick go at appending... (on a different machine as I don't have the required add-on), but this seems to just stack my data tables on top of one another, rather than consolidate and display in date order...

    I'm not precious on how it looks, the functionality is so much more important!

    Wow. I realize I might be asking for the world! Any and all advice welcomed, or if there's another way to achieve our challenge I'd love to hear it. And thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,511

    Re: Auto-populate front sheet or summary sheet with data from multiple tabs or sheets

    Yes, it can be done (I was using XL2007 until fairly recently).

    I'm just about to take a break now, though, so I'll pick it up later if no-one else has.

    Pete

  3. #3
    Registered User
    Join Date
    07-28-2021
    Location
    London, England
    MS-Off Ver
    365, 2008 Excel
    Posts
    5

    Re: Auto-populate front sheet or summary sheet with data from multiple tabs or sheets

    Oh my gosh Pete, thank you. No rush. I appreciate the response and super glad to hear its achievable!

  4. #4
    Valued Forum Contributor
    Join Date
    05-15-2017
    Location
    US
    MS-Off Ver
    365
    Posts
    792

    Re: Auto-populate front sheet or summary sheet with data from multiple tabs or sheets

    So you just need to consolidate all the date from all 3 tabs into the "Front Sheet"? So your front sheet would have 59 rows of data?
    If you find the suggestion or solution helpful, please consider adding reputation to the post.

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    18,764

    Re: Auto-populate front sheet or summary sheet with data from multiple tabs or sheets

    cmann89

    See if this is how you wanted.
    If not, I need to see your desire result in "Front Sheet".
    Please Login or Register  to view this content.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    07-28-2021
    Location
    London, England
    MS-Off Ver
    365, 2008 Excel
    Posts
    5

    Re: Auto-populate front sheet or summary sheet with data from multiple tabs or sheets

    Hi Cubangt, no not quite. I would like just some of the data from the three tabs into the front sheet, and then to display in date order... and then automatically update should a new row of data be added to any of the tabs.
    Hope that's clearer

  7. #7
    Registered User
    Join Date
    07-28-2021
    Location
    London, England
    MS-Off Ver
    365, 2008 Excel
    Posts
    5

    Re: Auto-populate front sheet or summary sheet with data from multiple tabs or sheets

    Hi Jindon, thank you so much - looks like I need to contact my IT team to get around the security macros - as soon as I've done this I'll be able to check what you've very kindly created for me. Will get back to you ASAP.

  8. #8
    Registered User
    Join Date
    07-28-2021
    Location
    London, England
    MS-Off Ver
    365, 2008 Excel
    Posts
    5

    Re: Auto-populate front sheet or summary sheet with data from multiple tabs or sheets

    Hi Jindon!
    I think this is great! I need to adjust the date range but I think this will work! Thank you

+ 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. VBA to Populate Summary Sheet with Totals from Multiple Sheets
    By PandoraGirl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2019, 09:20 PM
  2. Replies: 3
    Last Post: 11-10-2018, 06:59 AM
  3. Auto Populate New Sheet Based on Data from Multiple Other Sheets
    By NateD in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 04-28-2015, 03:00 PM
  4. How to: Turn Summary Sheet into detailed Sheets (multiple tabs)
    By JPWRana in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-20-2014, 06:18 PM
  5. Replies: 4
    Last Post: 05-02-2013, 04:39 PM
  6. 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
  7. Auto Populate Master Sheet with multiple sheets data
    By haley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-26-2009, 04:29 AM

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