PDA

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



mackypogi
05-31-2014, 06:39 AM
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
1608

here is the user form
1609

here should be the result.
1610

patel
06-01-2014, 09:31 PM
no jpg please but an excel sample file for testing

Excel Fox
06-03-2014, 03:48 PM
mackypogi, the snapshots aren't entirely conveying your requirement properly. Could you either rephrase, or, as patel suggested, attach a sample with the expected output