+ Reply to Thread
Results 1 to 3 of 3

Multiple Selection from a data validated list in the same cell

  1. #1
    Registered User
    Join Date
    12-10-2013
    Location
    London, England
    MS-Off Ver
    MS Office 365 Small Business
    Posts
    2

    Multiple Selection from a data validated list in the same cell

    Hi,
    I am trying to add a code so I can select multiple options from a drop down list so they then show in the same cell separated by comma's.
    The Drop down options start in cell B1 of sheet 'list options' and continue to cell B10 of the same sheet, i would like to be able to add these options to sheet 'job sheet' in column H from cell 1 onwards.
    I have also attached the spreadsheet if anyone can help it would be greatly appreciated
    J
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    09-17-2013
    Location
    East
    MS-Off Ver
    Excel 2010
    Posts
    55

    Re: Multiple Selection from a data validated list in the same cell

    Hey J,

    I'm not sure what you are actually trying to do?

    So the strings in column B of "list options" are supposed to be just listed in column H of "job sheet"?

  3. #3
    Registered User
    Join Date
    12-10-2013
    Location
    London, England
    MS-Off Ver
    MS Office 365 Small Business
    Posts
    2

    Re: Multiple Selection from a data validated list in the same cell

    Sorry if I wasn't clear enough.
    I want to make multiple selections that are comma seperated in column H using the option in column B - does that make more sense?
    Thanks

+ 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. Replies: 7
    Last Post: 05-27-2013, 03:58 AM
  2. [SOLVED] Macro that runs data-validated cell individually through the list it is based on - Part2
    By dks345 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2013, 06:00 PM
  3. [SOLVED] Macro that will run data-validated cell individually through the list it is based on
    By dks345 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-26-2013, 07:46 PM
  4. Replies: 2
    Last Post: 03-13-2013, 07:35 AM
  5. Data validation list multiple options problem when entering none validated data
    By ThomasCarter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2012, 05:53 AM

Tags for this Thread

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