how do I copy and paste cells with a macro?

[spamunch]

Someone on this forum was kind enough to help me with this code, I have follow up questions, but he is in New Zealand and it's saturday morning and I don't expect him to wake up and head straight to this forum. Project is almost due. I am stuck

The macro works well. If you click on the checkbox, the cell contents are copied and pasted from column k to column m and back. I want to be able to click and copy and paste data from columns I, J, K and back, and even from columns that are not next to each other. I cant figure it out. I keep getting compiler errors. I attached a dummy file of my work. It is in Excel 2007

Please Login or Register  to view this content.

Thank you very much

this is the important part.

Please Login or Register  to view this content.

Thank you for your help!

[crommel]

great script! is there a way to add a second column of checks, and when each is checked it will delete or hide the row, or move the row to another sheet?