I want to make a spreadsheet where user can check boxes on one worksheet, and have those values then be brought over, comma separated, into one cell, on another worksheet. The values of the checkboxes have to be capable of changing as a new row entry is made on the first spreadsheet.

I have the associated name text of the checkboxes populating into an adjacent column when the box is checked (TRUE).

This column is the one I want to pull the text from. I want it to also ignore blanks, and not include extra commas.

I am not familiar with VBA, but with some hand holding, I could use some. Clever formula approaches also welcome!

Thanks!