+ Reply to Thread
Results 1 to 4 of 4

Search for word in Cell> Cut Row> Paste into new sheet

  1. #1
    Registered User
    Join Date
    04-06-2013
    Location
    MN,US
    MS-Off Ver
    Excel 2010
    Posts
    2

    Search for word in Cell> Cut Row> Paste into new sheet

    I have an excel that has information all over the place. I need to be able to sort through almost 5,000 rows and multiple columns for specific words. I need a macro that can search the entire sheet, and not just a column or a row. I keep finding macros that search a specific column for the word > copy the row > paste to a new sheet....... Is there a way to search all cells for a specific word > cut row> move rows up> paste row into another sheet? Main thing being search all cells, because the information that i''m looking for isn't in the same column every time.

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Search for word in Cell> Cut Row> Paste into new sheet

    would the word seeked an exact match? or would it be part of a sentence within the cell?

  3. #3
    Registered User
    Join Date
    04-06-2013
    Location
    MN,US
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Search for word in Cell> Cut Row> Paste into new sheet

    It would be an exact match... I have already split the sentence out into individual cells.

  4. #4
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Search for word in Cell> Cut Row> Paste into new sheet

    although this is a working sub you have to tweak it to your needs...

    it does assume that it has headings in row 1 so the number of columns can be determined

    it uses the simplest way to make the seekd word a variable

    Please Login or Register  to view this content.

+ 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