I suggest you do not use checkboxes.
1. You will need to install a checkbox on every row
Which to do would require code to do that mostly
Then code would have to be written to determine which checkbox was check and what sheet to move this row to.
It can be done but not by me.
I suggest you double click on column A of your sheet.
And if you double click on "Alpha" this row will be copied to a sheet named "Alpha"
And if you double click on "Bravo" this row will be copied to a sheet named "Bravo"
Now if you want, we can delete the row form the original sheet if you want.
You will see I do have that line of code in my script but if you do not want that remove that line of code.
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
The script runs when you double click on any cell in column A
VBA Code:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'Modified 7/15/2022 12:41:36 AM EDT
If Target.Column = 1 Then
On Error GoTo M
Dim r As Long
Dim ans As String
ans = Target.Value
r = Target.Row
Dim Lastrow As Long
Lastrow = Sheets(ans).Cells(Rows.Count, "A").End(xlUp).Row + 1
Rows(r).Copy Sheets(ans).Rows(Lastrow)
Rows(r).Delete
End If
Exit Sub
M:
MsgBox "You double clicked on " & ans & vbNewLine & "This sheet does not exist"
End Sub
