+ Reply to Thread
Results 1 to 2 of 2

Set of keywords to search and move whole rows to another tab

  1. 02-07-2012, 01:09 PM #1
    lxdeb
    lxdeb is offline
    Registered User
    Join Date
    01-23-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    1

    Set of keywords to search and move whole rows to another tab

    Hi guys,

    I am sure its a piece of cake for experts. I am not progammer so for me its difficult.

    I would like to have a MACRO to search for bunch of keywords and the file which can have various number of rows.

    Something like that. I will top this set of keywords every now and then.
    Please Login or Register  to view this content.
    The macro should perform a search like filter and ideally move all rows which have any particular keyword to new tab or if its not possible I can do it manually, no probs.

    I couldn't find anything ready made on forums here because I can't really formulate the search correctly. Can anyone help in creation of this macro, please!

    Thanks
    Reply With QuoteRegister To Reply
  2. 02-07-2012, 03:17 PM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Set of keywords to search and move whole rows to another tab

    Envision an entire workbook where you will do all this.

    SHeet1... a list of words to search for in column A
    Sheet2... raw data to be searched
    Sheet3... the resulting extracted rows from Sheet2 using the search strings from Sheet1

    Can you put that workbook together showing us excellent sample Sheet2 data that you're searching through, and perhaps manually mockup your sheet3 results from your sample data?

    Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.

    Can you put a sample workbook together like that where the sheet2 shows real usable examples of the kind of data you're searching through?

    If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    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)

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