Discussion Locked

Transfer/Copy data random basis - Excel

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

by carquiza

Hi,

You can create or record a macro that accomplished what you want and debug it then you can used that macro if you need it again. Try to execute and a record a macro and run the macro again to attain the same action that the macro did but be sure that you saveas the original file while you are experimenting on the new save file. Hope this help a bit.

Then you will realize that you have done your own personal code to attain what you want.

Cheers,

Mel Arquiza
Home Page Design
http://hpd.welcome.to

This discussion is closed to new replies.