I'm have a project at work where I want to make multiselections of a list. These selections will again appear in the next column (or next row).
I've used datavalidation before, but I can then just make one selection, but I want to be able to make more than one selection from the list.


Maybe me issue becomes clearer with the following document:

test listbox.xlsx
(The document doesn't work on it self. It's just a visual replica of what I want to achieve)

I've seen a couple of videos on YouTube about ListBox, ComboBox and so on, but haven't quite gotten the help I need.


Looking forward to the replies (and sorry for my bad English)