Results 1 to 6 of 6

Vba code to search key words in descriptions column

Threaded View

  1. 03-17-2017, 12:18 AM #1
    xlhelp7
    xlhelp7 is offline
    Forum Contributor
    Join Date
    11-19-2015
    Location
    India
    MS-Off Ver
    excel 2013
    Posts
    124

    Vba code to search key words in descriptions column

    Hi All,
    In sheet1 in column A i have a List of key words and in sheet2 in column B i have descriptions .
    What I would like to do is this: I required a macro which would search all key words in cell B2 and if key words found then should paste these key words from D2 to xltoright and also counts of total key words found should come in Cell C2 and repeat same procedure for B3,B4 and so on so.
    Please find the attached sample file.The output data is showing in sheet3.

    Regards,

    xlhelp7
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. [SOLVED] Populate an empty column with descriptions from another spreadsheet if the code matches.
    By taylorcharley in forum Excel General
    Replies: 5
    Last Post: 12-11-2015, 09:34 AM
  2. [SOLVED] Search a column for up to 30 words then insert a different word in a separate column
    By SFore in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-18-2014, 05:13 PM
  3. Want an VB code to search / replace words in another macro
    By CatEnters in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2012, 07:49 PM
  4. [SOLVED] Search Cells for key words and add category code
    By Jimbo42 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-07-2012, 05:23 PM
  5. Search Multiple Words in a Column
    By homebuyinghq in forum Excel General
    Replies: 1
    Last Post: 09-24-2007, 01:24 AM
  6. How do I search for duplicate words in a column?
    By Manish Bajpai in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-06-2005, 02:05 PM

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