+ Reply to Thread
Results 1 to 9 of 9

Create unique list from multiple sheets

  1. #1
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    621

    Create unique list from multiple sheets

    Hi,

    Would somebody kindly help me with code for the following, please.

    I will eventually have 53 worksheets, Pay Week 1, Pay Week 2 etc. a new sheet is added each week
    In each sheet, I have lists of names varying in length but not greater than 300, all starting in C2

    I have a further sheet named YTD wherein I would like to create a unique list of these names starting in J3

    Thanks
    Kevin

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

    Re: Create unique list from multiple sheets

    It would be easier to help and test possible solutions if you could attach a copy of your file, de-sensitized if necessary.
    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
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    621

    Re: Create unique list from multiple sheets

    Thanks for looking
    Attached Files Attached Files

  4. #4
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    1,712

    Re: Create unique list from multiple sheets

    Possibly...
    Please Login or Register  to view this content.
    Last edited by dangelor; 06-13-2019 at 01:27 PM.

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    9,234

    Re: Create unique list from multiple sheets

    Another way
    Please Login or Register  to view this content.

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

    Re: Create unique list from multiple sheets

    Try:
    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    621

    Re: Create unique list from multiple sheets

    Thank you all for taking the time to help.

    All 3 solutions offered worked!

    Thanks
    Kevin

  8. #8
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    9,234

    Re: Create unique list from multiple sheets

    You're welcome & thanks for the feedback

  9. #9
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    1,712

    Re: Create unique list from multiple sheets

    Glad to hear it!

+ 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: 1
    Last Post: 02-07-2018, 08:00 AM
  2. Create Unique List from Multiple Criteria
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2015, 04:20 PM
  3. How do you create a unique list from multiple same named entries?
    By john dalton in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-08-2013, 03:57 AM
  4. Create unique list from multiple sheets with variable
    By The Phil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-18-2012, 07:14 PM
  5. create unique list from multiple values?
    By dragganm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-25-2011, 10:34 AM
  6. Importing values from sheets to create unique list
    By hawkteflon in forum Excel General
    Replies: 18
    Last Post: 06-08-2009, 02:46 PM
  7. Need to create unique list from list of multiple entries
    By Jeff in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-17-2005, 01:05 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