Results 1 to 17 of 17

Double Click and Copy Data

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-26-2008
    Posts
    124

    Double Click and Copy Data

    I have a sheet with some 300 plus rows of data. I use filters to sort through the rows to get down to anywhere from 8 to 10 or so rows. At that point I would like to be able to select (doule click) a filtered row of 10 cells (A:J) copy the data and paste it to a different sheet starting with cell B18. I want to be able to perform this process up to 5 seperate times.

    I have recorded a macro to do basically what I am trying but with many short falls. It only selects one row, I cannot double click on a row and it dosen't always paste to the proper cell.


    Sub CopyWoods()
    '
    ' CopyWoods Macro
    ' Macro recorded 6/2/2009 by Jim Ogier
    
        Sheets("Wood Shafts").Select
        Range("A15:J15").Select
        Selection.Copy
        
        Sheets("Input").Select
    
    ' Find next empty row
    n = Sheets("Input").Range("B18").End(xlUp).Row + 1
    
    ' Write values to next empty row
        ActiveSheet.Paste
    End Sub

    Any help would be greatly appreciated.

    Jim O
    Last edited by JOGIER; 06-20-2009 at 10:40 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1