+ Reply to Thread
Results 1 to 4 of 4

Macro To Find & Copy Rows Based On A Keyword List

  1. #1
    Registered User
    Join Date
    04-15-2012
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    1

    Macro To Find & Copy Rows Based On A Keyword List

    Hi,

    I've got an Excel document with over 7K entries and I need to search the data to find where ever a certain keyword is mentioned and copy the entire row into a separate sheet within the same workbook. However, I have a list of around 50 keywords so doing this using Ctrl+F would take some time. I'm new to Macros but I think that a macro may be the best solution for this task.
    The data is in Sheet1 and the particular column that needs to be searched is "K". The contents of column "K" is made up of words and sentences. Sheet2 is where I would like the found results to be copied to. The list of Keywords that need to be searched for are located in Sheet3, starting from Cell A1. Below is a list of the sort of words that need to be searched for:

    Jaguar
    Landrover
    Tata Motors
    Volvo
    Audi
    Mazda
    Vauxhall
    Opel

    Does anyone think they can help me create a macro to carry out this task or know of a better solution for doing it?

    Any help would be much appreciated.

    Thanks,

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Macro To Find & Copy Rows Based On A Keyword List

    Hi
    Upload sample data. Not all but with few at least...
    Click *, if my suggestion helps you. Have a good day!!

  3. #3
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Macro To Find & Copy Rows Based On A Keyword List

    Hi

    I have designed a macro with my own sample data. Pls try it on actual data.

    SEARCHKEYWORDS.xlsm

    Any probs pls do come back.

    Regards..

  4. #4
    Registered User
    Join Date
    07-01-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Macro To Find & Copy Rows Based On A Keyword List

    Hi, I was wondering if there's a way to alter the code so that it would search all of the columns in Sheet1? Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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