+ Reply to Thread
Results 1 to 10 of 10

Unique list from Multiple Worksheets

  1. #1
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2021
    Posts
    1,099

    Unique list from Multiple Worksheets

    Hi,

    I have a list of data in multiple worksheet with different worksheet names.What I want is that I want a unique lists from Column A3 & below in a New Sheet.While Extracting unique list it should also copy the data of Q & R column as well.

  2. #2
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2021
    Posts
    1,099

    Re: Unique list from Multiple Worksheets

    Pls find attached.I have kept only two worksheet.There is infact more than 2 worksheets.
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    455

    Re: Unique list from Multiple Worksheets

    Your example is one that is most difficult to follow. Please read rules. Simple suggestion is to create a Pivot table for the multiple selections, this should automatically create unique list. (your info without a solid example AND solution is too difficult for me to follow, BUT the Pivot table should help you get unique)

  4. #4
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2021
    Posts
    1,099

    Re: Unique list from Multiple Worksheets

    Ok how to do for column A assuming that there is no other colums in multiple worksheets.
    Last edited by paradise2sr; 07-13-2020 at 11:14 AM.

  5. #5
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,100

    Re: Unique list from Multiple Worksheets

    Try:
    Please Login or Register  to view this content.
    Click the * to say thanks.

  6. #6
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    11,358

    Re: Unique list from Multiple Worksheets

    Please Login or Register  to view this content.
    Last edited by sintek; 07-14-2020 at 06:00 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  7. #7
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2021
    Posts
    1,099

    Re: Unique list from Multiple Worksheets

    This issue already solved yesterday by PaulM.
    Thanks for your help as usually.

  8. #8
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    11,358

    Re: Unique list from Multiple Worksheets

    My apologies...

    Your thread was not marked as solved and PaulM100 solution did not incorporate the
    it should also copy the data of Q & R column as well.

  9. #9
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2021
    Posts
    1,099

    Re: Unique list from Multiple Worksheets

    Quote Originally Posted by sintek View Post
    My apologies...

    Your thread was not marked as solved and PaulM100 solution did not incorporate the
    yeah.I have mentioned to ignore for for data Q & R column if its not possible.And look for A column only.I will test today Post #6.
    I would be thankful to you further if it work out Q& R also.

    In the mean time I am marking this as solved.

  10. #10
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    11,358

    Re: Unique list from Multiple Worksheets

    I would be thankful to you further if it work out Q& R also.
    Post 6 solves...

+ 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. Create unique # of worksheets based on list count with unique names
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-24-2016, 09:51 AM
  2. Loop through worksheets, create unique list
    By cajand in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2015, 04:43 PM
  3. Replies: 8
    Last Post: 09-14-2013, 12:53 PM
  4. Copy Multiple Unique Values to Multiple Worksheets
    By cwafstet in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-26-2013, 10:14 PM
  5. Copy Multiple Unique Values to Multiple Worksheets
    By cwafstet in forum Excel General
    Replies: 1
    Last Post: 08-26-2013, 06:53 PM
  6. Help with running list of unique items across worksheets
    By BVT3030 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-11-2013, 04:15 PM
  7. count unique values in multiple worksheets with multiple criteria
    By craig04 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-06-2012, 03:26 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