Macro to cut and paste data to another based off of Check box.

Hello,

Fairly new to VBA but trying to learn.

My current task is to create a macro that cuts and pastes the complete row based off of a check box(Form Control).

Data will be in cells B to O with Check Boxes in P. What is the best way to have a button initiated macro that loops through the check boxes in P and if one is ticked then cut and paste the data into Sheet 2 (Archive) on the next available row?
This would also have to delete the check box in the original row and either not pasted into sheet 2 or not cut.

Any help would be greatly appreciated.

Many Thanks
James

This worked perfectly.

Thank you very very much AlphaFrog.