Create multple pick list

[Beermonster]

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?

[Skiptomylou]

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.

[Beermonster]

I've attached a sample

[Skiptomylou]

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

[Beermonster]

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