Im looking for a macro that can get a cell RANGE, the data in the RANGE will be copied then if the checkbox is selected it will copy the same data in the RANGE and add the selected checkbox in next column
Please see my sample below
here is my range below
Attachment 1608
here is the user form
Attachment 1609
here should be the result.
Attachment 1610
