+ Reply to Thread
Results 1 to 8 of 8

Looking for Help to find a set of words within a string, and move to another sheet

  1. 09-08-2015, 06:50 PM #1
    swade730
    swade730 is offline
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Looking for Help to find a set of words within a string, and move to another sheet

    Hi,

    Please see the enclosed workbook for what i am looking to accomplish.

    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-08-2015, 07:01 PM #2
    maym
    maym is offline
    Forum Contributor
    Join Date
    10-12-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016 in 2024
    Posts
    857

    Re: Looking for Help to find a set of words within a string, and move to another sheet

    do you want to cut the row and paste it to sheet 2 or copy the row? If cut, do you want to delete the blank row?
    Reply With QuoteRegister To Reply
  3. 09-08-2015, 07:10 PM #3
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Looking for Help to find a set of words within a string, and move to another sheet

    Not knowing your answer to maym, here is a start which copies and pastes.

    Please Login or Register  to view this content.
    HTH
    Regards, Jeff
    Reply With QuoteRegister To Reply
  4. 09-08-2015, 07:10 PM #4
    stnkynts
    stnkynts is offline
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Looking for Help to find a set of words within a string, and move to another sheet 

    Please Login or Register  to view this content.
    If you are happy with my response please click the * in the lower left of my post.
    Reply With QuoteRegister To Reply
  5. 09-09-2015, 09:56 AM #5
    swade730
    swade730 is offline
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: Looking for Help to find a set of words within a string, and move to another sheet

    maym I want to copy and paste the rows but it would be cool if I could return the value in a cell of the number of rows that were pasted or cut. But yes Maym, copy and paste is cool
    Reply With QuoteRegister To Reply
  6. 09-09-2015, 10:00 AM #6
    swade730
    swade730 is offline
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: Looking for Help to find a set of words within a string, and move to another sheet

    This is dirty, nice - marking as solved. Thank You
    Reply With QuoteRegister To Reply
  7. 09-09-2015, 11:17 AM #7
    swade730
    swade730 is offline
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: Looking for Help to find a set of words within a string, and move to another sheet

    Quote Originally Posted by stnkynts View Post 
    Please Login or Register  to view this content.

    What is this line implying?
    Reply With QuoteRegister To Reply
  8. 09-09-2015, 12:25 PM #8
    stnkynts
    stnkynts is offline
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Looking for Help to find a set of words within a string, and move to another sheet

    When you apply an autofilter, only the filtered cells will be visible. The line in question takes the visible (autofiltered) cells in a specific range (D2 to D and the last used row)(expanded to encompass the entire row) and copy/pastes to Sheet 2 cell A1
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find words with same pattern and length in a string
    By csam63 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-05-2015, 09:22 AM
  2. Find some words in a string
    By larrygoldstein in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-16-2014, 08:56 AM
  3. Find, List and Count All Words within a Text String
    By TheDrMrsSmith in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2014, 11:07 PM
  4. [SOLVED] Find text string exist in cell from keys words
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-11-2013, 01:56 AM
  5. [SOLVED] Macro to find rows containing certain words and move them
    By leah72 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2013, 12:39 PM
  6. Which function to find a words in word string and return them
    By majo. in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-27-2013, 09:08 AM
  7. How to move a whole row into a new sheet, when Column E has certain words in a sentance.
    By Nosey in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-19-2012, 05:19 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1