+ Reply to Thread
Results 1 to 7 of 7

Copy Cut Paste by Certain Value

  1. #1
    Registered User
    Join Date
    03-14-2007
    Posts
    58

    Copy Cut Paste by Certain Value

    If I highlight the text I want to move to a different sheet it works fine. See the attached spreadsheet. What I want is to have the macro find "Closed" which will only and always exist in the 'D' column. Highlight the three cells to the right, or can be the entire line, does not matter as there is only four columns of data and move it to 'Sheet 2'. Like I said if I highlight the rows I want and run my macro they move, I just don't want to have to highlight anything as this is going to be embedded into another macro and there is over 1000 rows of data.

    Any help would be appreciated.
    Attached Files Attached Files

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    See if this code helps from Ron's site

    http://www.rondebruin.nl/copy5.htm

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Registered User
    Join Date
    03-14-2007
    Posts
    58
    yes! exactly what i needed. thank you very much!

  4. #4
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Your welcome

    VBA Noob

  5. #5
    Registered User
    Join Date
    03-14-2007
    Posts
    58
    one more thing. i got everything working how i need it to. the only problem which is small is that it creates a new worksheet and pastes the results to that worksheet. i need it to paste to the end of an existing worksheet. i just noticed that.

  6. #6
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Assume you have the headers in Sheet 2 already try

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    VBA Noob

  7. #7
    Registered User
    Join Date
    04-14-2008
    Posts
    1

    copy the values below existing values

    Hi,

    Thanks for this code! I am also using it however I still have a problem with the following part of the code:


    In my sheet2, I have a first row with titles and I would like the macro to copy the values in A2. Then, when I rerun the macro I would like the marco to copy the items below the first ones. I suppose I need to use .End(xlDown) +1 line however I can't find the appropriate code...
    Can you help?
    Thanks!
    Last edited by VBA Noob; 05-16-2008 at 05:30 PM.

+ Reply to Thread

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