Transfer/Copy data random basis - Excel - TechRepublic
General discussion
March 22, 2002 at 02:30 PM
liaubon

Transfer/Copy data random basis – Excel

by liaubon . Updated 24 years, 2 months ago

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

This discussion is locked

All Comments