Here is some code for a check box alongside a row of data that will
1. Copy cells in one row and paste them into the same cells, same row, on another worksheet
2. Delete the source cells
In this example when the check box is checked, the data is copied and
when the checkbox is cleared the data is erased.
Private Sub CheckBox1_Click()
If Me.CheckBox1.Value = True Then
ActiveSheet.Range("G5:L5").Value = ""
The destination range in this example is the same range as the source, but on a different worksheet.
If you wanted, you could use a fixed range as the destination, so that only one set of data ever shows in the destination sheet
It looks as though you might have been trying that. Is "TechSum" a named range?
If you use a named range it needs to be the same size as the data you are copying, or a single cell.
If it is larger than the source, Excel will copy the source data to fill the range.
If you are building a table on the destination worksheet, you will need some more code to position successive rows.
Please explain or give some examples of how the source data is to be positioned in the destination sheet.