Move row to another worksheet if checked

[QualitySoup]

Hi, all

I'm Creating a job board where I need a row moved from a "Working Jobs" spreadsheet to a "completed Jobs" spreadsheet once the checkbox for said row has been checked. Can I get some assistance with this? Thanks!

 

[My Aswer Is This]

Try this script:
To run the script, you must double click on column 3 of the sheet you put this script in.
If will copy this row to a sheet named "CONFSENT"
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'Modified  7/20/2022  7:24:58 PM  EDT
If Target.Column = 3 Then
Cancel = True
On Error GoTo M
Dim r As Long
Dim ans As String
ans = "CONFSENT"
r = Target.Row
Dim Lastrow As Long
Lastrow = Sheets(ans).Cells(Rows.Count, "C").End(xlUp).Row + 1
Rows(r).Copy Sheets(ans).Rows(Lastrow)
Rows(r).Clear
End If
Exit Sub
M:
MsgBox "You double clicked on " & ans & vbNewLine & "This sheet does not exist"
End Sub