Cut and paste selected rows from sheet 1 to sheet 2 when check box is ticked

Hi,

I am new to this forum so hi and so sorry in advance if i dont make any sense.

I need help in relation to codes, macro and check boxes.

I have a spreadsheet (Sheet 1) which stores my list of jobs which are currently on hand and yet to be completed. I want to add a check box in the end column which will allow me to tick the box once the job is completed and then that particular row will cut and paste to (sheet 2).

I dont have much knowledge with Codes so will need a great deal of advice and simple steps how to do it from scratch.

Please note i have set up my excel with the developer tab. I have also attached the excel sheet so you can get an idea of what i want.

Hope you guys can help me. Thanks

No check box needed, right click in column I

Please Login or Register  to view this content.