To constantly transfer/Copy data on a random basis from a single row to another sheet in the same workbook.
One column (J) is now being used to colour code the existing “Cut & Paste” method which is very slow.
Column (J) can be used for “Ref Greg Harris Article Use Excel Checkboxes” check box’s & clicked in the row to be transferred.
Cells in the selected row of column’s A to H & from T to AQ need to be transferred & a colour fill placed in the cell in column A to identify that this row has been transferred to the next vacant line in another sheet.
How best can this be done ?????????
Any assistance is greatly appreciated