transfer/Copy data on a random basis with check box
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: transfer/Copy data on a random basis with check box

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Warwick Australia
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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 ?????????

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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.



User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com