+ Reply to Thread
Results 1 to 5 of 5

Create multple pick list

  1. #1
    Registered User
    Join Date
    04-30-2007
    Posts
    30

    Create multple pick list

    Hi

    I want to create a template to import products to my site, I have lots of categories on it and it would be handy if I could chose the category or several categories for each product before I import them, I use a Mac so can't use VBA, is there a way to have a list of the categories in one tab and click in the cell on the to select them?

  2. #2
    Registered User
    Join Date
    12-21-2015
    Location
    United States
    MS-Off Ver
    2016
    Posts
    62

    Re: Create multple pick list

    I'm not entirely sure what you are asking for, but it sounds like you are just looking to create some data validation tables based off pre-existing options.

    Are you able to attach a file and maybe a better description of what you are after?

    To add attachments:
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Registered User
    Join Date
    04-30-2007
    Posts
    30

    Re: Create multple pick list

    I've attached a sample
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    12-21-2015
    Location
    United States
    MS-Off Ver
    2016
    Posts
    62

    Re: Create multple pick list

    Selecting multiple options at one time from a data validation list is not possible without VBA that I am aware of.

  5. #5
    Registered User
    Join Date
    04-30-2007
    Posts
    30

    Re: Create multple pick list

    Thanks, I thought I could only use VBA on a windows machine, I was wrong, I've managed to do it

+ 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. I would like to create an excel sheet with pick from the list option
    By rakul_rakul in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-31-2015, 01:43 PM
  2. Create pick-list from a master list
    By jen0dorf in forum Excel General
    Replies: 6
    Last Post: 06-01-2014, 06:19 AM
  3. [SOLVED] Trying to create a pick list from an order
    By BrianSells in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-06-2012, 04:56 PM
  4. How to create a Multi-pick list
    By gurp99 in forum Excel General
    Replies: 1
    Last Post: 04-20-2010, 05:12 PM
  5. [SOLVED] How to create pick list in VBA
    By John in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-15-2006, 03:20 PM
  6. Create a pick list to use to go to a text cell in Excel
    By Pegita in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. [SOLVED] Create a pick list to use to go to a text cell in Excel
    By Pegita in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 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