+ Reply to Thread
Results 1 to 2 of 2

Help combining text column from multiple worksheets into single column, single worksheet?

  1. #1
    Registered User
    Join Date
    01-29-2020
    Location
    Illinois
    MS-Off Ver
    10
    Posts
    1

    Question Help combining text column from multiple worksheets into single column, single worksheet?

    I've got an abbreviated sample file attached. I have an Excel file containing multiple worksheets, each with a column of text information (names of people). The number of names in each worksheet varies. I want to copy those names from each worksheet into a single, new worksheet. Ultimately, I want to alphabetize that single column as well as eliminate the duplicate names, such that I end up with a list of all the unique names from the multiple worksheets. Seems relatively complex to me, but hopefully not so much to more experienced users. Thank you.
    Attached Files Attached Files
    Last edited by mblanco59; 01-29-2020 at 05:03 PM.

  2. #2
    Valued Forum Contributor dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Agawam, MA
    MS-Off Ver
    Microsoft Office 365
    Posts
    842

    Re: Help combining text column from multiple worksheets into single column, single workshe

    I believe the easiest way of getting your results would be to use a macro, which many users on here are sure to be able to create for you.
    <----- If you are happy with your solution please click on the "* Add Reputation" as a way to say 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. Combining multiple columns data into a single column
    By tmor in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-25-2016, 07:12 PM
  2. [SOLVED] Copy column data from multiple worksheets to single worksheet based on header criteria
    By nateaskins in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-21-2014, 10:42 AM
  3. [SOLVED] Count text in one column Matching single or multiple Criteria from Other Column Excel 2003
    By Jose Macieira in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-17-2013, 06:55 AM
  4. [SOLVED] Pull data if there is any from a single column in multiple worksheets into a single sheet
    By bcas77 in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 07-11-2013, 01:22 PM
  5. [SOLVED] Combining multiple columns of data into single column
    By dsklein85 in forum Excel General
    Replies: 6
    Last Post: 10-30-2012, 11:18 PM
  6. Replies: 4
    Last Post: 09-14-2009, 09:57 PM
  7. Combining like worksheets into a single worksheet
    By JAS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-14-2006, 11:30 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