I constantly transfer data on a random basis from a single row (the row will change on each random transfer) 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.

This column (J) could be used to place an X or a Yes in the cell of the row to be transfered.

Cells in the selected row of the column's A through to H & T through to AQ need to be transfered, & at the same time a colour fill be placed in cells of the same row in column A & B to indentify that this row has been transfered.

How best can this be done ?????????????????

[ This Message was edited by: HarryLiaubon on 2002-03-17 14:46 ]

[ This Message was edited by: HarryLiaubon on 2002-03-17 14:48 ]