+ Reply to Thread
Results 1 to 5 of 5

Extract text from one row and copy to unique row

  1. #1
    Registered User
    Join Date
    03-01-2016
    Location
    HK
    MS-Off Ver
    2000
    Posts
    3

    Extract text from one row and copy to unique row

    What I want to do is to extract data from one row and copy it to unique row
    What function can be used so that the result like below one

    123123123123.png

  2. #2
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: Extract text from one row and copy to unique row

    VBA solution. May need to change the name of your sheet with the data on it in the first line of code.

    Also assumes your names column is column 1, if not, change the column number on the With line to match the column with the names in it.

    Please Login or Register  to view this content.
    I'm interested in starting a career working with VBA, if anyone knows of any opportunities!

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Extract text from one row and copy to unique row

    Although I can't open the PNG, it looks to me that this is a crosspost.

    Please read the forumrules, especialy the ones about crossposting.

    http://www.mrexcel.com/forum/excel-q...nique-row.html
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  4. #4
    Registered User
    Join Date
    03-01-2016
    Location
    HK
    MS-Off Ver
    2000
    Posts
    3

    Re: Extract text from one row and copy to unique row

    it runs perfect, thanks a lot~

  5. #5
    Registered User
    Join Date
    03-01-2016
    Location
    HK
    MS-Off Ver
    2000
    Posts
    3

    Re: Extract text from one row and copy to unique row

    That also me , two code with different style
    but both can solve the problem, thanks all of 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. Extract unique text values from a filtered list
    By ljerromes in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-23-2015, 07:51 PM
  2. [SOLVED] Extract Unique Text Values based on Multiple Criteria
    By Kattenhove in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-26-2014, 07:59 AM
  3. [SOLVED] extract unique values & create new text file
    By hluk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2013, 07:34 PM
  4. [SOLVED] Extract/Copy Text from Cell, and insert that text in a new row below
    By jamesoneill in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-07-2013, 09:06 AM
  5. Extract unique rows and incremental copy
    By vedamv in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2006, 03:48 AM
  6. Extract Unique Values, Then Extract Again to Remove Suffixes
    By Karl Burrows in forum Excel General
    Replies: 23
    Last Post: 06-25-2005, 08:05 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