transfer/Copy data on a random basis with check box

HarryLiaubon · Mar 23rd, 2002, 12:59 AM

I 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 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 of the same woork book.

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

Dave Hawley · Mar 23rd, 2002, 01:06 AM

Hi Harry

A simple copy/cut and paste of data from one sheet to another shouldn't take any longer than one second.

I cannot quite understand your explanation and/or the problem.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 23rd, 2002, 12:59 AM	#1
HarryLiaubon New Member Join Date: Mar 2002 Location: Warwick Australia Posts: 3	I 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 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 of the same woork book. How best can this be done ?????????

Mar 23rd, 2002, 01:06 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Harry A simple copy/cut and paste of data from one sheet to another shouldn't take any longer than one second. I cannot quite understand your explanation and/or the problem.