HarryLiaubon
New Member
- Joined
- Mar 14, 2002
- Messages
- 3
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
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