+ Reply to Thread
Results 1 to 10 of 10

How to generate a master list of all names and other data from multiple tabs

  1. #1
    Registered User
    Join Date
    03-28-2017
    Location
    Memphis, TN
    MS-Off Ver
    OFFICE 365
    Posts
    8

    How to generate a master list of all names and other data from multiple tabs

    I have a workbook that has 17 tabs; each with a unique name. I am wanting to get a formula or way to transfer all of that data onto one master list tab. The columns are all going to be the same I just need the data to go on its own row.
    Attached Files Attached Files

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: How to generate a master list of all names and other data from multiple tabs

    .
    Paste into a Routine Module :

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-28-2017
    Location
    Memphis, TN
    MS-Off Ver
    OFFICE 365
    Posts
    8

    Re: How to generate a master list of all names and other data from multiple tabs

    Thanks for your quick response! This was perfect! i really like the refresh button you added on the master tab!
    Last edited by Scott.Applewhite; 07-25-2017 at 08:13 PM.

  4. #4
    Registered User
    Join Date
    03-28-2017
    Location
    Memphis, TN
    MS-Off Ver
    OFFICE 365
    Posts
    8

    Re: How to generate a master list of all names and other data from multiple tabs

    Is there any way to not have the header row from all of the tabs return on the master page multiple time? Not a huge issue, this will work for what I need but just curious.
    Thanks again for your help!

  5. #5
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: How to generate a master list of all names and other data from multiple tabs

    I don't understand why it would be copying row 1 from each sheet to the master ... it does not do that here.

    It only copies Row 2 and down to the last used row.

  6. #6
    Registered User
    Join Date
    03-28-2017
    Location
    Memphis, TN
    MS-Off Ver
    OFFICE 365
    Posts
    8

    Re: How to generate a master list of all names and other data from multiple tabs

    Well everything was going well until i went to load it into Google Docs only to realize that Google Drive does not support VBA.......uggggg Do you know a easy way to convert this string so it will work while in Google Drive?

  7. #7
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: How to generate a master list of all names and other data from multiple tabs

    .
    I am not familiar with Google's form of Excel. I only know that most of it is compatible with Excel but there are a few quirks.

    Sorry.

  8. #8
    Registered User
    Join Date
    03-28-2017
    Location
    Memphis, TN
    MS-Off Ver
    OFFICE 365
    Posts
    8

    Re: How to generate a master list of all names and other data from multiple tabs

    Does anyone now a better way to get this document to populate a master list of names and info from other tabs? I am going to load in to either One Drive or Google docs so that over a dozen people can add names to the document and then i would like it to automatically update the Master list of names and info.
    Attached Files Attached Files

  9. #9
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: How to generate a master list of all names and other data from multiple tabs

    .
    I got to looking at the macro and experimenting. Previously all the sheets had some kind of test data. When I cleared one sheet of all data except the Column Headers, I saw what you are seeing on your end.
    The macro, for that single sheet, was copying the headers and pasting them to the Master List sheet.

    Having changed the macro around, see if this works better for you :

    Please Login or Register  to view this content.

  10. #10
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: How to generate a master list of all names and other data from multiple tabs

    Hey Scott,

    How about another idea here. What if each person had their own workbook with a single sheet, where they add data. Then you put all their workbooks into a single directory/folder and append all of them to a single workbook. This is a new feature in Excel 365 called Get & Transform. No VBA needed.

    http://excelunplugged.com/2015/02/10...n-power-query/
    https://support.office.com/en-us/art...8-6a00041c90e4

    The beauty of this is you can have more and more people add files to the folder and simply run the PQ again and it will gather up all those files into a single master.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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. Replies: 2
    Last Post: 06-30-2015, 04:45 PM
  2. [SOLVED] I need to compare student quiz submission names/grades against a master list of names.
    By NoxExcel in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-15-2013, 08:00 PM
  3. Generate list of names based on multiple criteria
    By mattadler22 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-03-2013, 06:02 PM
  4. Can you auto create multiple tabs from enterting data in a master sheet's column?
    By ambermorr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2013, 07:28 AM
  5. Replies: 1
    Last Post: 07-20-2012, 07:51 AM
  6. Replies: 1
    Last Post: 02-22-2012, 01:57 AM
  7. Generate List of Matching Rows from multiple tabs
    By xenocide8d in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-02-2010, 12:52 AM

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