+ Reply to Thread
Results 1 to 4 of 4

Creating a comma seperated list based on a search criteria from a column

  1. #1
    Registered User
    Join Date
    10-28-2013
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    2

    Creating a comma seperated list based on a search criteria from a column

    Hello everyone.

    I have spent the last 2 days trying to find out how to do this, but I am not getting anywhere. I am not great with excel but can usually find a work around for things, but this time I am stumped.

    I have to create from a list of child SKU'S in a cell, comma seperated that relate to the parent items in a file I have to create (there are over 2000 parent items, totally around 44000 skus when you include the child items, so manually is out of the question).

    The idea being, that when I import the parent item product, in one cell there is a list of the child items for that product. Hopefully the image below helps explain.

    Attachment 274052

    Thanks in advance for any help.

    Steve

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,894

    Re: Creating a comma seperated list based on a search criteria from a column

    To attach a Workbook
    (please do not post pictures of worksheets)
    • Click Advanced (next to quick post),
    • Scroll down until you see "Manage Attachments",
    • Click that then select "add files" (top right corner).
    • Click "Select Files" find your file, click "open" click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Click "Done" at bottom right to close the Attachment Manager.
    • Click "Submit Reply"
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    10-28-2013
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Creating a comma seperated list based on a search criteria from a column

    as requested
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,894

    Re: Creating a comma seperated list based on a search criteria from a column

    One solution per the given sample:
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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 file
    By scotthomas in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-06-2012, 03:46 PM
  2. Comma seperated list of numbers
    By krspa9 in forum Excel General
    Replies: 1
    Last Post: 07-24-2009, 05:24 AM
  3. Creating a list in one column based on criteria in two other columns!?
    By chelseasikoebs in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-02-2009, 11:00 PM
  4. Reading from comma seperated List
    By Shashi Bhosale in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2005, 03: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