PDA

View Full Version : Copy range and paste depending on the selected checkbox



mackypogi
05-30-2014, 06:47 PM
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. right now i dont have a code.

Please see my sample below

here should be the range

11757

then this is the form,
11758

if all the check box is selected it should display

11759

patel
05-31-2014, 05:46 AM
no jpg please but xlsm file for testing