Hi Peter

If you use Linkedcell for each checkbox you can use AutoFilter to
filter on TRUE.
This way you can copy it to a new sheet

Maybe you like this
http://www.rondebruin.nl/copy5.htm




--
Regards Ron de Bruin
http://www.rondebruin.nl



"Peter" wrote in message ...
Hello All,
I am trying to figure out how to copy values from a range to another range.

I have a checkbox setup in each row from 16-45. If the checkbox is ticked it
will copy the range "B(row number)" to "K(same row number)" to a new sheet
and insert it under the last entry within rows 16-45.
There are no formula's or anything to be copied, just the cell contents.
Any advice welcomed

Regards
Peter