I am trying to find a way to have all selected values from a drop list (with multiple values selected) to also displayed/copied in a cell (say A25). This so later on you push a button and the values in cell A25 are copied with other values that were entered in other cells to a new row.
So eventually the sheet will fill up with rows that display some manually entered values and a cell that contains a sting of text (made up from the values that were selected from the dropdown menue).
The list contains names, that i want to be displayed in the A25 cell as text separated by a comma.
Exm. Dave, Partic, Simon
Thank you for your time and effort.