+ Reply to Thread
Results 1 to 8 of 8

Create a master list of names from multiple tabs

  1. #1
    Registered User
    Join Date
    03-29-2017
    Location
    manchester
    MS-Off Ver
    2013
    Posts
    56

    Create a master list of names from multiple tabs

    wondering if somebody could help me out.

    I'm after a VBA that will copy all the names from columns D, E & F in each worksheet and then create one master list in another tab.

    Thanks in advanced...

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: Create a master list of names from multiple tabs

    DO you want the names from each column underneath each other in one column or do you want to keep them in 3 columns? What is the name of the destination sheet and where on that sheet do you want to copy the names?
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Registered User
    Join Date
    03-29-2017
    Location
    manchester
    MS-Off Ver
    2013
    Posts
    56

    Re: Create a master list of names from multiple tabs

    Hi Mumps1,

    Thanks for your prompt response, id like to keep the 3 columns please and the destination sheet is called 'Full List'
    all the names in each sheet will start from row D4, E4 & F4 and the 'Full List' is in the same format.

    thanks

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: Create a master list of names from multiple tabs

    Try:
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    03-29-2017
    Location
    manchester
    MS-Off Ver
    2013
    Posts
    56

    Re: Create a master list of names from multiple tabs

    Hi Mumps1,

    thanks for that, it works but it has also copied a lot of blank cells between the multiple sheet data. is there anyway it can copy only the cells with names in?

  6. #6
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: Create a master list of names from multiple tabs

    Could you attach a copy of your file so I can see how your data is organized?

  7. #7
    Registered User
    Join Date
    03-29-2017
    Location
    manchester
    MS-Off Ver
    2013
    Posts
    56

    Re: Create a master list of names from multiple tabs

    I've managed to sort it, it was picking up empty cells that had boarders around them.
    I have removed the boarders and it has solved the problem.

    thanks for your help!

  8. #8
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: Create a master list of names from multiple tabs

    My pleasure.

+ 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. How to generate a master list of all names and other data from multiple tabs
    By Scott.Applewhite in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-26-2017, 08:23 PM
  2. [SOLVED] How to create Multiple sheets base on a list and a MASTER sheet
    By davi65 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2016, 11:06 AM
  3. collating multiple tabs within same workbook to create a master/summary tab
    By xotrujillo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-02-2016, 05:15 PM
  4. [SOLVED] How to create a master list worksheet from lists of names on several worksheets
    By ESUCP Jamie in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 07-20-2015, 03:03 PM
  5. Replies: 2
    Last Post: 06-30-2015, 04:45 PM
  6. [SOLVED] Create master list from multiple sheets in the same format
    By malmandras in forum Excel General
    Replies: 1
    Last Post: 05-09-2013, 01:59 PM
  7. 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

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