+ Reply to Thread
Results 1 to 8 of 8

VBA code to create comma seperated list with one condition

  1. #1
    Forum Contributor
    Join Date
    02-24-2011
    Location
    Los Angeles, CA
    MS-Off Ver
    Office 2010
    Posts
    164

    VBA code to create comma seperated list with one condition

    I have a spreadsheet with two different tabs. I need to be able to make a comma separated list in one cell in sheet two of the firm column, where there is one condition; called "full name". I found several spots online to do this without a condition, but how do I do it with one condition. Sample attached, if this makes any sense...

    Using Excel 2010.
    Attached Files Attached Files
    Last edited by Delta729; 04-04-2018 at 11:26 PM.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,465

    Re: VBA code to create comma seperated list with one condition

    Try
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    02-24-2011
    Location
    Los Angeles, CA
    MS-Off Ver
    Office 2010
    Posts
    164

    Re: VBA code to create comma seperated list with one condition

    Sorry, I should also mention... I'm a complete idiot when it comes to vba. Do I put this into a module?

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,465

    Re: VBA code to create comma seperated list with one condition

    See attached.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    02-24-2011
    Location
    Los Angeles, CA
    MS-Off Ver
    Office 2010
    Posts
    164

    Re: VBA code to create comma seperated list with one condition

    Got it, thanks so much.

  6. #6
    Forum Contributor
    Join Date
    02-24-2011
    Location
    Los Angeles, CA
    MS-Off Ver
    Office 2010
    Posts
    164

    Re: VBA code to create comma seperated list with one condition

    Jindon helped me last night making a comma separated list from table1 in sheet1 and inserting into table2 on sheet2. Unfortunately, I marked the thread as solved and I am trying to make an alternate version; where each item in the list wouldn't be in a comma separated list, but more of bullet point list. Each new item in the list would have a chr(10) & Chr(149), and start off with the first item in the list with chr(1469) as well. I was hoping I could figure out how to modify the code, but nothing is working. Can anyone lend a hand?

  7. #7
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,465

    Re: VBA code to create comma seperated list with one condition

    Change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    02-24-2011
    Location
    Los Angeles, CA
    MS-Off Ver
    Office 2010
    Posts
    164

    Re: VBA code to create comma seperated list with one condition

    Perfect, thank you so much. I tried to make it work, but it looks like I wasn't even close.

+ 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. Creating a comma seperated list based on a search criteria from a column
    By HUGH JORGAN in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-30-2013, 05:20 PM
  2. Comma Seperated Value Files
    By TheRevenant in forum Excel General
    Replies: 4
    Last Post: 06-12-2013, 01:22 AM
  3. [SOLVED] Macro to change data entered in a cell seperated by a comma, into a vertical list of data
    By jholly3 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-13-2012, 03:51 PM
  4. Have 300 cells, want them in one, seperated by comma
    By AdamParker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-04-2009, 01:58 PM
  5. Comma seperated list of numbers
    By krspa9 in forum Excel General
    Replies: 1
    Last Post: 07-24-2009, 05:24 AM
  6. How to split a value seperated by comma?
    By Ticktockman in forum Excel General
    Replies: 2
    Last Post: 03-23-2006, 12:25 PM
  7. [SOLVED] Reading from comma seperated List
    By Shashi Bhosale in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2005, 03:05 PM
  8. Combine names seperated by comma
    By bbc1 in forum Excel General
    Replies: 3
    Last Post: 02-13-2005, 04:06 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